To see a list of all tabs you right click on the arrows to the left of the tabs. Is there a shortcut to this without a mouse?

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

Ctrl+pageup/pagedown to move across tabs or enter the following macro into your personal macro workbook and assign it a shortcut or put it on the QAT and access via Alt + its number.

Sub ShowAllSheets()

Application.CommandBars("Workbook tabs").ShowPopup

End Sub

like

Yes but what’s the shortcut to it with only using a keyboard

like

Following

You just need to right click the space next to the left arrow at the very left end of the navigation bar. It will give you the whole list of tabs in the worksheet.

I've tried looking through forums and such in the past. As far as I know, there isn't one.

Related Posts

Need 11 likes

like

Angering mummies is exactly what we need right now.

Post Photo
funnylikehelpful

Any of you men get waxed? Usually trim, but want to give it a shot. Any advice?

likefunny

Hello fishes...
What are some Exit options available for Digital Trust - CDSG Consultant ?

like

Hi Novartis people, can any body share the revised pay benchmark (cuz of EPIC pledge) for Manager and Senior Manager/Team Lead roles? Is it to start from this year or if it would be enacted in 2023-2024 cycle

like

I need some advise. I am a relatively new adjuster. I have 7 years of experience in the insurance industry, a bachelors degree in Business and an AINS from the institutes. I currently work as a GL adjuster with a TPA. I have seen a high turnover rate on my team in my short time at this position. I received maybe 2 hours of formal training and the rest has been learn by fire, even with claims in litigation. It’s a nightmare. I can’t get 5 minutes of my managers time a day. Would you leave?

like

Could someone please refer me at JPMC for Java Full Stack with 2.5 YOE, if you can. LWD Aug 17

like

I have worked with Forbes top companies, for-profits, non-profits, & startups. I consider myself a solver of complex & complicated problems requiring mixed method research & novel solutions. This has led to issues in self-referencing title. I’ve been project manager, data engineer, developer, modeler, analysts, principle DB developer, etc. Most of my w2 work has been from offers of 1099 clients so I am usually asked to define my own title. Any T-shaped data people who run into this?

like

Hello fishes,
Can u pls name a few reputed MNCs in Pune location working in Data Science domain like TCS, Accenture, Capgemini?

like

Hi Team,

Need help
I'm looking for a Job change _ Manual testing Engineer_ core banking _functional_UI/UX_JIRA _postman API.

Please refer if any openings.
Notice period : 30 days

like

Starting in HR…
The ‘smarter way’ of becoming HR Business Partner… what positions should I start with? Titles that help you gain needed experiance? Any suggestions? Recommendation?

like

Any advice for a failed designer who needs to pivot? I want to be a copywriter at a digital agency. Unsure what to do in the meantime.

like

Wednesday Wordle 298 4/6

⬛⬛🟨⬛⬛
⬛⬛⬛🟩⬛
⬛⬛⬛🟩⬛
🟩🟩🟩🟩🟩

like

Requesting referral for Test Engineer with 2.7 years of mobile application testing, manual testing experience.

like
like

Has anyone considered moving from NYC to Houston? Any advice of why not to do it apart from the Texas heat. The homes are so much bigger and taxes much lower.

like

Is Amazon losing its prestige?

like

Anyone else still gets impostor syndrome (even with several years experience in software engineering)? Any tips you use to overcome it?

like

What is the right time to switch? January?

like

Additional Posts in Excel Genius

Hey all, for VBA what would the code be for searching for a specific value in column A and once that value is found go to the next row, do a loop that basically copies and pasted that value into Column C, the next row would then be copied and pasted in column D, then next to E, F, and G then back to C…. Until another specific value is found?

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

I have a formula that returns a value of any cell in that row is blank otherwise it says error. However I only want the formula to apply if any of the cells in the row are populated. Help?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Anyone here get their Masters in Finance? What do you do now?

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

Is there an easy way to convert a manipulated pivot table to a normal table but automatically retain all the subtotal formula and grouping? For example, I have a pivot table with 3row fields (country, region, customer) And a 1 column field by month. I want to make a presentation to show top 5 customer by country and region….and group rest as “all other”….thanks’!!🙏

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

I have a workbook with a couple of custom lists that we use every month in my department. I'm handing off this responsibility to someone else who will be using their own laptop to do it. Will the custom lists pull over to their version, or do we have to set them up in their version of excel on their laptop?

like

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

How can I pull the text before a certain set of characters?

likesmart

What am I doing wrong in my sum product formula? I keep getting an error message.

Post Photo
like

Anyone know the shortcut to format selected cells as short date IE mm/dd/yyyy?

likesmart

What are your favorite excel macros to make you more efficient at work?

like

Is there a better tool than than Excel for making models? What do you use?

like

Can somebody help me with the IF formula here please? I want to match Column K and Column O with No as the select values. I’ve tried =IF(K6=O6=“No”, ”match”) but it didn’t work. Thanks in advance for your help!

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

like

Hotkey question. Let's say I have 10 rows of data. Added a new column, want to quick fill cells. When I use Ctrl+ down, it select 10k rows because they are all blank. Any better option??

likefunny

Need to count attendance per office location. Looking for cell formula that gives me live view of “yes” (attendance) when attendee is assigned to “x” office. Keep trying IFS but getting 0.

Is Windows (vs Mac) really the way to go with Excel? (Starting MBA, concentrating in Finance)

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