Four Excel quick tips to navigate data faster

excel MBA & Business
By Enrique

Screen Shot 2019-07-31 at 2.01.28 PM"Give it to me in Excel." There's a high probability that you've heard this phrase in school, at work, or from someone that needs data. Excel has made it tremendously easy to sift through data and make it more interpretable. The vast majority of users in the business world use Excel, so it pays to be well-versed in this powerful tool. During my time working in the finance industry, I found Excel invaluable, and I committed these tips to muscle memory. I learned that these shortcuts helped me save a tremendous amount of time.

Here are 4 Excel quick tips to help you navigate data faster.

Note: The keyboard shortcuts given here apply to Windows operating systems.

1. Moving to the last column or row in a dataset

  • CTRL + Up arrow/down arrow/left arrow/right arrow

If you’ve had to navigate through a dataset that has multiple rows and columns, then you might have made your way to the last row or column by either using the arrow keys on the keyboard or using the scroll bars on the bottom or side of the screen. For a dataset that has hundreds of rows or columns, getting to the end of your dataset might have taken some time. Think of all of the time you could save if you could snap to the last row or column in a dataset -- there's a way to do this! If you hold the CTRL key on your keyboard and then press the arrow key that is pointing in the direction that you want to go, then you’ll immediately go to the last contiguous cell in that row or column. If the row or column that you are on is missing data points, then pressing CTRL and the arrow key will snap to the last cell with data in it (i.e. right before the break in the dataset).

last_row

last_column

2. Navigating to other tabs in the workbook

  • CTRL + Page up/Page down - Windows/full keyboard
  • CTRL + fn + up arrow/down arrow - Windows/most laptops

I find it inefficient to click between different tabs in a workbook especially If I’m in the middle of typing a really long text block or formula and I need to reference something else in another tab. Besides breaking up whatever flow you were in, the action of going from keyboard to your mouse can take up tons of time (on a cumulative basis). Save time by using your keyboard to navigate to tabs to the left of the current tab (CTRL + Page Up) or to the right of the current tab (CTRL + Page down).

switching_tabs

3. Highlighting/selecting multiple cells

  • SHIFT + arrows

To select a group of cells, all you need to do is hold the shift key and then selecting the cells you need by using the arrow keys. Combine this with #1 (i.e. CTRL + SHIFT + arrow key) to select all contiguous cells in a row or column.

highlighting_cells

4. Highlighting / selecting an entire row or column

  • SHIFT + space bar: highlight entire row
  • CTRL + space bar: highlight entire column
This one can come in handy - if you need to highlight an entire row or column to, let’s say, change the font or font size, use these shortcuts to ensure everything in that row or column is being formatted.

Here's my challenge to you: as you go through your next dataset, try resisting the urge to use your mouse (or mousepad) when you have to perform any of the actions above. Keep using these keyboard shortcuts until it becomes second nature. Once you master these shortcuts, you can combine them with other keyboard shortcuts to perform commands in seconds! Save seconds, save time, and navigate data faster!

highlighting_rows

highlighting_columns

Comments

topicTopics
academics study skills MCAT medical school admissions SAT expository writing college admissions English MD/PhD admissions strategy writing LSAT GMAT GRE physics chemistry math biology graduate admissions academic advice ACT interview prep law school admissions test anxiety language learning premed MBA admissions career advice personal statements homework help AP exams creative writing MD study schedules test prep computer science Common Application summer activities history mathematics philosophy organic chemistry secondary applications economics supplements research 1L PSAT admissions coaching grammar law psychology statistics & probability legal studies ESL CARS SSAT covid-19 dental admissions logic games reading comprehension engineering USMLE calculus PhD admissions Spanish mentorship parents Latin biochemistry case coaching verbal reasoning DAT English literature STEM excel medical school political science skills AMCAS French Linguistics MBA coursework Tutoring Approaches academic integrity chinese letters of recommendation Anki DO Social Advocacy admissions advice algebra art history artificial intelligence astrophysics business cell biology classics diversity statement gap year genetics geometry kinematics linear algebra mechanical engineering mental health presentations quantitative reasoning study abroad technical interviews time management work and activities 2L DMD IB exams ISEE MD/PhD programs Sentence Correction adjusting to college algorithms amino acids analysis essay athletics business skills careers cold emails data science dental school finance first generation student functions graphing information sessions international students internships logic networking poetry resume revising science social sciences software engineering tech industry trigonometry writer's block 3L AAMC Academic Interest EMT FlexMed Fourier Series Greek Health Professional Shortage Area Italian Lagrange multipliers London MD vs PhD MMI Montessori National Health Service Corps Pythagorean Theorem Python Shakespeare Step 2 TMDSAS Taylor Series Truss Analysis Zoom acids and bases active learning architecture argumentative writing art art and design schools art portfolios bacteriology bibliographies biomedicine brain teaser campus visits cantonese capacitors capital markets central limit theorem centrifugal force chemical engineering chess chromatography class participation climate change clinical experience community service constitutional law consulting cover letters curriculum dementia demonstrated interest dimensional analysis distance learning econometrics electric engineering electricity and magnetism escape velocity evolution executive function freewriting genomics harmonics health policy history of medicine history of science hybrid vehicles hydrophobic effect ideal gas law immunology induction infinite institutional actions integrated reasoning intermolecular forces intern investing investment banking lab reports linear maps mandarin chinese matrices mba medical physics meiosis microeconomics mitosis mnemonics music music theory nervous system neurology neuroscience object-oriented programming office hours operating systems

Related Content