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

formating

ResolvedVersion 2003

michael has attended:
Excel Intermediate course

Formating

Please can you explain the best ways to use formating

RE: formating

Hi

This depends on what you are trying to format. Charts etc can be formatted as well as cells for example. Date formats in cells would depend on the date format the user is more comfortable with etc. What are you trying to format?

thanks

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.