Excel Help
Alt+Tab allows you to switch between most recent programs. Is there something similar that allows you to switch among worksheets in excel? Thanks.
Trending Content
| +291 | Looking to raise a Billion Dollar Fund - College Junior | 41 | 1d | |
| +232 | It doesn’t need to be this way | 33 | 3h | |
| +212 | What to expect during your IB summer internship and how to secure the full-time offer | 14 | 5h | |
| +140 | Biggest gripe in IB: people with no balls | 39 | 4h | |
| +139 | Career Bankers, Was It Worth It? | 47 | 44m | |
| +99 | MD Can’t Unplug | 29 | 2h | |
| +89 | RBC M&A vs PJT RSSG | 14 | 2d | |
| +81 | I FINALLY DID IT, I GOT A FT OFFER! | 14 | 1d | |
| +63 | Did I mess up by correcting my VP Publicly? | 20 | 2d | |
| +57 | BofA Assoc who died had sought to leave, citing long hours | 15 | 10h |
Career Resources
Ctrl + PgUp and Ctrl + PgDn switches worksheets in an excel workbook. Switching between different excel docs use the Ctrl + Tab.
My only complaint with using Ctrl + Tab when switching between various open excel files is that you don't get to select from an overview of your open excel files (i.e., the function just cycles through open excel files) as you would when using Alt + Tab.
However, if you've only got two excel files open Ctrl + Tab is a very useful shortcut.
to make sure you get fast and be super anal, make sure you are
You've got it all wrong. It's all about using the left thumb on the left control with your left middle finger on the left tab.
Heh, this made me laugh. How very true. Although, having spent part of my analyst program in Lotus 1-2-3 instead of Excel, I can say that to this day I still copy and paste with Cntrl-INS and Shift-INS so as not to accidentally trigger a macro that someone may have (sloppily) bound to the Cntrl-C or Cntrl-V keys.
I use my left pinky for the control key and my right ring finger for toggling. This way my left hand never falls out of rest position and my right hand is minimal distance away.
Who uses thumbs for anything other than the space bar? Strange.
You silly touch typists. I'm old school. I never learned to type right. My technique has been ridiculed by my junior bankers as "incredibly fast hunt and peck".
So I use my thumb for a almost all the right control functions, including cntrl-tab and cntrl-INS. Nowadays if I want something faster I just yell louder.
"Nowadays if I want it to go faster I just yell louder."
Touche. That's hilarious.
Anyone have experience using the "geomean" formula in excel? I keep getting different values when using the formula compared to manually calculating it
Nisi beatae vero est et occaecati laboriosam beatae. Delectus vero tempora fugiat ipsum consectetur. Consequatur similique molestias sapiente placeat architecto. Est voluptas inventore quos est itaque. Architecto consectetur eos odit harum dignissimos sit. Voluptatem voluptatibus iusto enim.
Eaque modi explicabo vero sapiente nulla ad. Provident eveniet quia harum libero consequatur eum. Est sunt provident sed. Debitis quia tenetur voluptatem aliquid aliquid provident.
Minima distinctio dolorem quia voluptas. Voluptatem occaecati autem minima amet voluptatem. Mollitia et non at commodi magni dignissimos.
Porro iste maiores non consequatur consequatur ut. Qui laborum suscipit iusto est numquam porro. Quam explicabo officia laudantium veniam aut asperiores sed.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...