Excel Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2346261%22%20slang%3D%22en-US%22%3EExcel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2346261%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20working%20with%20macOS%20Big%20Sur%2011.3.1%20using%20Excel%20for%20Mac%20version%2016.49.%26nbsp%3B%20I%20opened%20%22View%2C%20Headers%20and%20Footers%22%20to%20change%20a%20page%20number%20on%20the%20document%2C%20and%20now%20I%20cannot%20get%20%3CSTRONG%3Eout%3C%2FSTRONG%3E%20of%20Headers%20%26amp%3B%20Footers.%26nbsp%3B%20It%20shows%20in%20the%20dropdown%20box%20under%20%22view%22%20that%20I%20am%20not%3CSTRONG%3E%20in%3C%2FSTRONG%3E%26nbsp%3BHeaders%20%26amp%3B%20Footers%2C%20but%20actually%20I'm%20%3CSTRONG%3Elocked%20into%20that%20view%3C%2FSTRONG%3E.%26nbsp%3B%20I've%20tried%20pressing%20ESC%2C%20closing%20and%20reopening%20the%20document%2C%20asking%20for%20help%20on%20Excel%20help--about%20everything%20I%20could%20think%20of%2C%20but%20I've%20been%20locked%20out%20for%2012%20hours.%26nbsp%3B%20I%20do%20not%20want%20to%20lose%20the%2013%20pages%20of%20data%20I've%20typed%20into%20the%20document.%26nbsp%3B%20Please%20offer%20help.%3C%2FP%3E%3CP%3EDonna_P%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2346261%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2347462%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2347462%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1051211%22%20target%3D%22_blank%22%3E%402021Donna_P%3C%2FA%3E%26nbsp%3BSame%20configuration%20as%20yours.%20Going%20the%20%22Headers%20and%20Footers...%22%20via%20the%20View%20menu%20takes%20you%20to%20%22Page%20Layout%22%20view%2C%20indicated%20in%20the%20bottom%20right%20hand%20corner%20of%20the%20Excel%20window.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-12%20at%2006.14.33.png%22%20style%3D%22width%3A%20168px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280191i01D5249DE13CCA51%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-12%20at%2006.14.33.png%22%20alt%3D%22Screenshot%202021-05-12%20at%2006.14.33.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20icon%20in%20the%20middle%20is%20greyed.%20Click%20on%20the%20icon%20to%20the%20left%20to%20go%20back%20to%20%22Normal%22%20view.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm working with macOS Big Sur 11.3.1 using Excel for Mac version 16.49.  I opened "View, Headers and Footers" to change a page number on the document, and now I cannot get out of Headers & Footers.  It shows in the dropdown box under "view" that I am not in Headers & Footers, but actually I'm locked into that view.  I've tried pressing ESC, closing and reopening the document, asking for help on Excel help--about everything I could think of, but I've been locked out for 12 hours.  I do not want to lose the 13 pages of data I've typed into the document.  Please offer help.

Donna_P

1 Reply

@2021Donna_P Same configuration as yours. Going the "Headers and Footers..." via the View menu takes you to "Page Layout" view, indicated in the bottom right hand corner of the Excel window.

Screenshot 2021-05-12 at 06.14.33.png

The icon in the middle is greyed. Click on the icon to the left to go back to "Normal" view.