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

formatting

ResolvedVersion 2007

Val has attended:
Upgrade to Office 2007 course

Formatting

How do you use formulas

RE: Formatting

Hi Val

Could you give me an idea of the type of formula you are looking to create? This is quite a large topic so you may wish to attend one of our Excel courses. I'd be happy to help you with a specific formula though.

David

RE: Formatting

Hi Val,

As this question has been left unanswered for a couple of months, the system will automatically mark this query as resolved in the next 5 days if we don't hear from you.

If you still require assistance with this query, please post a reply and we will assist you further.

Thank you.

Rich

Mon 24 Nov 2008: Automatically marked as resolved.

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.09 secs.