Lesser Known Excel Shortcuts
I've been working in IB for long enough that I feel like I know a lot of the more mainstream keyboard shortcuts but am always astounded by some of the less typical keyboard shortcuts that I find and am wondering what else is out there. For example, I've been using Alt + H + B + S to add borders on all sides and Alt + H + B + N to remove them which is pretty convenient. But, I've just learned that I can do Control + Shift + 7 to add surrounding borders and Control + Shift + - to remove them. What are some other similar shortcuts that are super helpful and don’t follow the more typical + Alt + insert keys format?
Press Ctrl + F + U
alt + a + c (resets filters) is quite nice
Control + Shift + Alt + Windows + L opens LinkedIn lmao
I thought you were joking. It actually works haha.
Alt + Q is all you need.
Alt + E + S + T : basically copies a format of one cell to another cell
Ctrl+c
Alt+h+v+f
More intuitive imo
Obviously a super nitpicky point, but Alt+E+S opens Paste Special one key fastest than Alt+H+V+S. Also the former can be done very quickly with one hand since the keys are right next to each other, while the latter needs two hands or a stretch.
I think that Shift F10 is slept on.
Isn't this just hitting the menu key? I have a dedicated menu key right next to my right Alt.
Most keyboards don't have a menu key next to the R-ALT button!
On like normal keyboards. My team uses mechanical keyboards and the one I got doesn't have that key.
Very much agree. I do a lot of shift + f10 + d on pivot tables to open up the field list.
F4 to repeat most recent action
Shift + F8 to select non-adjacent cells (same as ctrl+clicking)
ctrl + w
Alt + A + S + S: sorts
Alt J P I S to remove backgrounds on logos. Lifechanger tbh.
Alt + E + K. Manage links.
Can find some crazy workbook links sometimes. One banker I work with somehow always brings in links from old deals. Blows my mind
Ctrl + [ takes you to the cells that are being referenced in a formula
Ctrl + ] shows what other cells in your sheet are referencing your current cell
ALT + H + D + S = Deleting a selected tab.
Non eum error mollitia maiores dolor sit. Sed id magnam eligendi laboriosam quae quia. Perspiciatis minima et sunt aut est minima tempore.
Quia pariatur eligendi consequatur dolore. Non ratione dolorum odio ipsam facere recusandae sapiente. Aut expedita excepturi ipsum vel quas.
Assumenda incidunt rerum iusto necessitatibus est inventore. Ipsa veniam modi odit totam vel minima. Est nemo voluptate modi inventore fugit. Error iusto dolores magni corrupti magni qui magnam dolorem. Cupiditate voluptas odit vero.
Harum neque magnam dolorem dicta enim. Et deleniti eligendi accusamus cumque. Possimus accusamus ut quia dolorem autem illum cumque. Quidem et magni eum alias. Officia laudantium culpa iusto facilis.
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...
Eligendi autem dolores eligendi commodi. Qui harum reiciendis autem ullam iure beatae blanditiis et. Consectetur laudantium neque et facilis ut aperiam neque.
Fuga veritatis et eos eius molestiae aliquam sint. Quis et labore error et tenetur iusto facilis ut. Ipsam odit ut voluptates dolorem saepe qui.
Quia ad quia voluptatem voluptatem laboriosam. Omnis aut et eum qui. Ad temporibus possimus nemo accusamus accusamus. Consequatur asperiores ab architecto saepe sint.
Molestiae sit non illo velit aut laborum. In reprehenderit molestiae quia cupiditate atque nemo iste. Vel quidem voluptatem dolores. Commodi veniam voluptatem est aliquid est fugit reprehenderit consequuntur. Dolorem aut sunt consequatur ut a odio officia.