microsoft excel courses in london - gridlines

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in london - Gridlines

microsoft excel courses in london - Gridlines

resolvedResolved · Low Priority · Version Standard

John has attended:
Excel Introduction course

Gridlines

How can i create agridded form when all cells are not filled in

RE: Gridlines

Hi John

Thanks for your question.

I'm not entirely sure what you mean by creating a gridded form, but maybe it would help if you applied borders to the cells you wish to have lines around.

To do this, select the cells and choose Format - Cells - Border, or you can use the border button on the formatting toolbar to apply borders to cells (next to the Fill colour button with the paint bucket on it).

Amanda


 

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.1 secs.