Home For AAT student members AQ 2013 AAT Level 3 (Level 6 in Scotland)
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚

Header & footers in excel

HopeipassxHopeipassx Feels At HomeRegistered Posts: 66

Can someone please tell me once I have added my header in footer on a spreadsheet, how then do I get out of it? It keeps me in it and the spreadsheet layout looks different?


  • twinks01twinks01 Settling In Nicely Registered Posts: 16
    There are three little squares on the bottom right of the window with little tiny pictures on them. The one on the left shows the spreadsheet as you would normally see it, the middle one is where you see it with the headers & footers and the right one shows the print area with blue lines. So pressing the square on the left should hopefully get you back where you want to be.
    Then again, it is quite possible I am wrong!

    Are you doing the spreadsheet unit next?
  • HopeipassxHopeipassx Feels At Home Registered Posts: 66
    Thats brilliant - thank you so much, it was bugging me for ages!!!

    Yes I am doing spreadsheet unit, ive got a exam in 4 weeks, so fingers crossed!!! :)
  • twinks01twinks01 Settling In Nicely Registered Posts: 16
    Me too! How are you getting on with pivot tables and lookup things? Hope you pass your exam!
Sign In or Register to comment.