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.