Forum Discussion
Worksheets
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?
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.
Hope that helps
3 Replies
What could be else - some banking software generates Excel files where tabs area is minimized to zero, like this
If focus the mouse on 3 dots and drag to the right tabs will appear:
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.
Hope that helps
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.
