excel

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

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

Excel

resolvedResolved · High Priority · Version 2003

Abimbola has attended:
Excel Intermediate course

Excel

How do i summarise a large worksheet?

RE: Excel

Hi Abimbola,

Thank you for your question.

You can use the Subtotals tool to summarise a large worksheet.

Sort your data by one of the column headings. Then go to Data, then subtotals. Choose the field you sorted by, then select the function you want and finally the field you want to subtotal.

Regards

Simon


 

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


Server loaded in 0.08 secs.