Copying from Filtered Excel Spreadsheet

Resolved · Low Priority · Version 2007

Wed 19 Feb 2014, 10:25 Delegate Kate said...

Kate has attended:
Excel Advanced course

Copying from Filtered Excel Spreadsheet

Please would you remind me of the keyboard short cut copy function required to copy only the filtered visible data?

Thanks,
Kate

Wed 19 Feb 2014, 11:04 Trainer Gary said...

RE: Copying from Filtered Excel Spreadsheet

Hi Kate

Thanks for getting in touch. The key combo you are after is

CTRL *

I hope that helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips