automatically select a column and row automatically excel for mac 2011

Automatically Select A Column And Row Automatically Excel 2011 Mac 2011 Will
Automatically Select A Column And Row Automatically Excel 2011 Professional Presentations And

Automatically Select A Column And Row Automatically Excel 2011 Mac 2011 Will

Excel for Mac 2011 will indicate the selected cell in several different ways.

The address is the column letter followed by the row number.

To change the color of the selection indicator, choose Apple MenuSystem PreferencesPersonalAppearance to display the Appearance dialog.

Click the Highlight Color to display a pop-up menu from which to choose a different color.

If you have Excel open when you make these changes, you have to close and restart Excel to see the change in the cell border color.

When more than one cell is selected or referred to at a time, its called a cell range.

When you release the mouse button, the range of cells becomes highlighted, and the row numbers and column headers are darkened to indicate the selected range.

Type A1:C5 in the cell address box, in cell formulas, or in dialogs to indicate a range of cells whose top-left position is A1, and whose bottom-right position is C5.

Clicking this button selects all the cells of a worksheet at once.

With the whole sheet selected, you can apply formatting options to the entire sheet.

Automatically Select A Column And Row Automatically Excel 2011 Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

Automatically Select A Column And Row Automatically Excel For Mac 2011