How many tabs is too many for a single spreadsheet?

likefunny
Posting as :
works at
You are currently posting as works at

Who is the audience and what is there comfort with Excel. There are some people I work with that I can barely send a multi page pdf to - much less a multi tabbed excel file.

likefunny

If you can limit it to tabs that display on the bottom without having to arrow over or scroll I think you're safe. Once they start getting hidden, a good portion of people won't realize they are there. If you need more than stay visible on a 16" laptop, I'd consider adding a navigation menu with home and back buttons on each tab to help those that may need it.

like

It depends. What are your alternatives? Who will be using it?

like

And is your organization using 32-bit or 64-bit Excel.

like

Thanks. I thought that is what you meant.

Use vlookups and your good

Till it bogs down or users get lost. Use an index page to help from getting lost.

Depending on what the tabs are, when the total effort of maintaining and using it exceed the effort it would take to do the same thing with something else. That could be PowerQuery within excel itself, or PowerBI/tableau if all the tabs are transforming data and pivot tables/charts. Notion, air table, or an outright database if it’s a ton of data. On and on, going back to what SM said about who is using it and what you’re doing

Related Posts

This one is for folks on h1b visa. So at time when you have an offer in hand(not accepted the offer yet and h1b transfer process not yet begun) while you are working with your current employer, do you even speak to your employer about your new offer to see if they make a counter offer?
Is there a risk involved with this approach assuming your current employer doesn't provide you with a counter offer and they ask you to leave immediately (and your h1b visa hasn't been transferred either)

like

Anyone work or has worked at MGO?

like

Honest thoughts on Horizon? What are their toughest accounts to work on?

like

BakerTilly people, what application do you use to prepare your financial statements? Do you use word/excel?

likefunny

Hi fishes,
Wanted to know what is the probation period in cognizant and what is np in tht probation. Joined cogni in sep. Please help. @cognizant

like

Who was around in 2008/2009 at big 4? Specifically in advisory? How were those practices affected during the layoffs? Any insight to ease some of the worry/unknown would be greatly appreciated.

likehelpful

Will there be layoffs at grip/dentsu? just saw that they’re folding the Grip agency brand 👀

like

Is the mobile phone reimbursement money given by Deloitte or pwc for new joiners??
If yes how much is the maximum

like

[Help]

I started trading during Covid crash. Started with equities and eventually moved to options. Earlier lost a month's salary and then lot more trying to recover it. Currently have lost my yearly salary worth and it's affecting all aspects of my life (job, marriage, health). I have tried to convince myself to consider it a loss but always get back trying to recover it.

Any advice how to deal with it. Thanks.

likesmart

Did you have a mentor coming up in Advertising? Your thoughts?

like

What is your favorite holiday tradition/event to attend in San Diego?

like

Sooooo when MBB says cover letters are optional, I should still write one right? They’re “optional”? Just hate cover letters 😫

like

Hi Fishes,

Can anyone help the ctc of Associate II in Transfer Pricing department in PWC AC (with 2 years of YoE)? Is there city wide difference?

like

Feelin' pretty loose and conversational, you guys

like

Having gone through a very underfunded public school system I felt inadequate and I was able to coast by through college. Though I feel like Im capable now I still feel inadequate sometimes. Thoughts?

Is the difference between the 5th and 6th edition Manhattan GMAT complete set enough to warrant spending the extra money on it? I can found all the 5th edition books for free online. 6th is $100 used

like

Hi All,

I am looking for a new opportunity on ITSM domain accross India on an immediate basis. Please let me know in case you can extend any help.


Prompt response is appreciated

What do you think of Just Egg?

like

Not bad for a Tuesday :)

Post Photo
likeuplifting

𝐔𝐊 & 𝐄𝐮𝐫𝐨𝐩𝐞: Few Recent Notable SuccessFactors EC & ECP Country Specifics!

#SAP #SuccessFactors #HXM #Europe #UK

Post Photo

Additional Posts in Excel Genius

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

How do you fix microsoft excel cannot paste data error?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Would anyone be willing to teach me vlookup?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Anyone know what these badges are?

Post Photo
likefunny

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

How do I compare two sheets to make sure they are identical?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Any book recommendations on excel modeling for real world business applications?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal