Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tables created

Tables created

ResolvedVersion Standard

Fri 15 Jun 2007, 12:49 Delegate Rebecca said...

Rebecca has attended:
Access Introduction course
Excel Intermediate course

Tables created

Whats the easiest way to change the table layout?
i.e. outlines etc

Mon 18 Jun 2007, 11:27 Trainer Richard said...

RE: Tables created

You can use something called AUTOFORMAT.

From the menu bar, simply click on FORMAT > AUTOFORMAT and then choose the layout that you want.

You can also use outlines to hide or show data using a button.
Simply select the rows or columns that you want to group together, then choose DATA > GROUP and OUTLINE > GROUP.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

Tables created

Tables created

RE: Tables created

Excel articles

Excel tip:

Shortcut for deleting all comments in a spreadsheet