answersLogoWhite

0

There is no shortcut key for fill left like there is for fill right. You can use the key combination to activate the fill left option from the menu. So you could use Alt+E+I+L. Another thing you can do is select the cells you want to fill into, with the one you want to fill from at the right end. If the value is already in the cell, then press F2. If not, you can type in the value. In either case, then, instead of pressing the enter key, hold the Ctrl key and press the enter key. It will fill in the selected area. This method can be used to fill any area with a set of values or formulas, not just those to the left.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is text alignment shortcut key justified?

Excel does not have any shortcut keys for aligning text. See related links for all shortcut keys for Excel 2007.


What are the steps to start Microsoft excel?

Create a shortcut key by right clicking on the excel icon on the desktop or from the folder menu and click properties. Define your shortcut key. Can do from the keyboard once this is done.


Is there a shortcut key for fractions?

Not in Excel. Excel does not use fractions. If you need to use fractions, then turn them into decimals. You can represent 1/2 in excel with the formula =1/2.


Another option to launch the Microsoft Excel?

you can assign shortcut key to application by right clicking and choose properties then under shortcut key assign something you will remember


Function key for go to?

That depends on the application. Commonly it is the F5 key, like in Word and Excel. Ctrl-G can be used as the shortcut.


What is the shortcut key in Microsoft Excel to copy a formula from the cell above instead of dragging it?

Ctrl-D


Should you press ctrl to display underlying formulas used in the worksheet?

You can display formulas by using the keyboard Shortcut CTRL + ` in Excel. (The ` Grave Accent key is below the ESC Key on the upper left side of most keyboards.)


What shortcut key do you press to unfreeze column and row titles?

There is no shortcut key to do this, but you can press Alt + W + F + F in Excel 2007 to access menu options to toggle between freeze and unfreeze panes. (I do not remember if this same sequence works with Excel 2003; you might just have to press F one time in Excel 2003.)


What is a shortcut menu in excel?

If you right-click on the mouse or hit the shortcut menu key on your keyboard, a menu appears with common commands that are used or are relevant at the time depending on what you are doing. This menu is known as a shortcut menu.


What is the shortcut key used to left-align a paragraph?

Ctrl - L


What keyboard shortcut command turns on the Selection mode?

Pressing F8 will start selection mode in Excel.


In excel what you need to do to move a screen to the left press?

Press the Home key or left arrow key.