SOLVED
Home

Worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-275552%22%20slang%3D%22en-US%22%3EWorksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275552%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20working%20with%20Excel%202013%20for%20years%20then%20bought%20Office%20365.%26nbsp%3B%20First%20job%20with%20new%20Excell%20I%20downloaded%20some%20bank%20data%20as%20Excel%20files%20and%20I%20cannot%20find%20a%20way%20to%20label%20a%20worksheet%2C%20or%20even%20see%20a%20tab.%26nbsp%3B%20I%20want%20to%20create%20multiple%20worksheets%20by%20copying%20from%20different%20Excel%20files%2C%20then%20consolidate%20all%20data%20into%20a%20common%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%20that%20I%20cannot%20see%26nbsp%3Bworksheet%20tabs%20in%20an%20.xlsx%20Excel%20file%3F%26nbsp%3B%20Is%20this%20an%20option%20setting%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-275552%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eworksheets%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276009%22%20slang%3D%22en-US%22%3ERe%3A%20Worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276009%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Haytham!%26nbsp%3B%20That%20works%20perfectly.%26nbsp%3B%20The%20Bank%20software%20downloads%20files%20in%20.XLM%20format%20which%20I%20saved%20as%20.XLSX%20format.%26nbsp%3B%20Maybe%20that%20is%20why%20that%20option%20was%20not%20set%20in%20the%20.XLSX%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275643%22%20slang%3D%22en-US%22%3ERe%3A%20Worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275643%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20could%20be%20else%20-%20some%20banking%20software%20generates%20Excel%20files%20where%20tabs%20area%20is%20minimized%20to%20zero%2C%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20295px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57789i44A51C9FB6A30D2F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20focus%20the%20mouse%20on%203%20dots%20and%20drag%20to%20the%20right%20tabs%20will%20appear%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20420px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57790iF04F2669DEAD8ADB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275554%22%20slang%3D%22en-US%22%3ERe%3A%20Worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275554%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Patrick%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20go%20to%20Excel%20Options%20%26gt%3B%26gt%3B%20Advanced%2C%20then%20scroll%20down%20until%20you%20find%20this%20checkbox%20as%20shown%20in%20the%20screenshot%20below%2C%20and%20make%20sure%20it's%20checked.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57770iF5B74D3A36B5825E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Show%20sheet%20tabs.png%22%20title%3D%22Show%20sheet%20tabs.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
Patrick Wood
New Contributor

I've been working with Excel 2013 for years then bought Office 365.  First job with new Excell I downloaded some bank data as Excel files and I cannot find a way to label a worksheet, or even see a tab.  I want to create multiple worksheets by copying from different Excel files, then consolidate all data into a common worksheet.

 

What am I doing wrong that I cannot see worksheet tabs in an .xlsx Excel file?  Is this an option setting problem?

3 Replies
Solution

Hi Patrick,

 

Please go to Excel Options >> Advanced, then scroll down until you find this checkbox as shown in the screenshot below, and make sure it's checked.

Show sheet tabs.png

 

Hope that helps

What could be else - some banking software generates Excel files where tabs area is minimized to zero, like this

image.png

If focus the mouse on 3 dots and drag to the right tabs will appear:

image.png

 

Thanks Haytham!  That works perfectly.  The Bank software downloads files in .XLM format which I saved as .XLSX format.  Maybe that is why that option was not set in the .XLSX file.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies