General Facilities in Microsoft Excel

Updated: May 26

#shortcuts #selecting #columns #rows

By: Tony Gaskell

Shortcuts

To enter cell references or cell ranges while you’re writing a formula, just click on the cell(s) instead of typing in the formula.


Pressing F9 forces a recalculation (useful if you have a random number generator).

Clicking a cell and then pressing F2 allows you to edit the formula.


Pressing End on the keyboard and then an arrow key will move the selected cell as far in that direction until it reaches a non-empty cell.

Selecting

You can select multiple areas if a spreadsheet by holding down the Shift key as you do so. You can select multiple single cells, cell ranges or a mixture. This is useful if you are formatting a lot of cells at once.

A whole row/rows can be selected by clicking the row label to the left of the screen.


A whole column/columns can be selected by clicking the column label to the top of the screen.


Changing Column and Row Width

The heights of the rows can be changed by clicking and dragging on the lines between the row headings on the left. If you double-click the line, it will automatically size the row to the largest height of the cells in the row.


The widths of the columns can be changed by clicking and dragging on the lines between the column headings at the top. If you double-click the line, it will automatically size the column to the largest width of the cells in the column.



Autofill

When you click on a cell, you will notice a border around the cell along with a larger square in the bottom-right corner. This is the Fill Handle.

When a value or formula has been entered, it can be easily copied to other cells by clicking the cell you want to copy and then clicking and dragging the Fill Handle to the cells you want to paste.


This also works for patterns of numbers, days or months. Enter at least the first three numbers in a linear number pattern. Highlight the three numbers. Then click and drag the Fill Handle. This will continue the pattern for as long as you want.


You can also enter Monday or January, select it and use the Fill Handle to show all the days of the week or months of the year.


18 views0 comments

Recent Posts

See All