Are you frustrated with spending too much time on a single Excel task? You don’t need to be! With these 10 essential shortcuts, you can master the spreadsheet in no time. Learn how to speed up your workflow and maximize your Excel productivity.
Ten Essential Excel Sum Keyboard Shortcuts for Efficient Navigation and Data Management
Time is important when dealing with Excel data. That’s why keyboard shortcuts are great! Let’s cover 10 essential ones for sums. First, we’ll show you how to go to the start of any row quickly. Then, we’ll reveal shortcuts to move to the end of a row. Also, we’ll demonstrate how to go to the beginning of any column at speed. Lastly, you can say goodbye to endless scrolling as we show you how to move to the end of any column with ease. These shortcuts make Excel data management a breeze!
Image credits: pixelatedworks.com by Joel Woodhock
Quickly Move to the Beginning of a Row with Ease
To make navigating spreadsheets easier, you can use these keyboard shortcuts:
- Press the “Home” button at the top right-hand side of your keyboard. This will take you back to cell A1.
- If you want to get back to the beginning quickly, press Ctrl + Home.
These shortcuts can save you time, especially when scrolling through spreadsheets with lots of rows.
Excel is a great tool and mastering its essential keyboard shortcuts is a great asset. It will save you time and make data entry tasks much faster.
Next, learn how to “Effortlessly Move to the End of a Row.”
Effortlessly Move to the End of a Row with Simple Shortcuts
Tap into the power of keyboard shortcuts for Excel and save time! Easily move to the end of a row with a few keystrokes. Here’s how…
- Ctrl+Right Arrow moves the cursor to the last non-blank cell in a row.
- Hold Shift + Ctrl+Right Arrow to select cells from the current position to the last non-blank cell.
- Press Shift+Spacebar, then Ctrl+Shift+Right Arrow to select an entire row.
- Use End key followed by any arrow key (Up, Down, Left, or Right) for movements without the Ctrl key.
- Ctrl+Left Arrow or End Key + arrow keys for backward navigation.
Make navigating lengthy rows effortless. Incorporate these shortcuts into your workflow today and get the most out of your data!
Next up: Navigate Like a Pro: Move to the Beginning of Any Column in Seconds.
Navigate Like a Pro: Move to the Beginning of Any Column in Seconds
Pro-level Excel navigation? Learn how to get to the beginning of a column in no time. Here’s how:
- Ctrl + Left Arrow
- Use F11 if you’ve set up a data table
- Shift + Spacebar selects a whole column
- Ctrl + Spacebar selects an entire row
- Ctrl + Home keys take you to cell A1 fast
- Scroll bar on the worksheet bottom right for quick navi
Navigating Excel quickly and efficiently is important for getting the job done. The “Navigate Like a Pro: Move to the Beginning of Any Column in Seconds” title sums it up.
Think of a database with thousands of records. You could search for ages, or you could use the handy keyboard shortcuts listed to save time.
The manager who was desperately looking for sales figures during a meeting? He wasted several minutes scrolling through the sheet before realizing he didn’t need to scroll at all. Just a few simple keyboard shortcuts would have given him instant access.
No More Scrolling: Move to the End of Any Column with Keyboard Magic. Learn these essential shortcuts and max out your workflow efficiency.
No More Scrolling: Move to the End of Any Column with Keyboard Magic
Tired of scrolling endlessly through Excel columns, trying to find the last entry? With these four keyboard shortcuts, you can move around your worksheet with ease.
- Ctrl + Arrow Down Key: This will take you to the last cell in the column that contains data.
- Ctrl + Shift + Arrow Down Key: Use this if the data is not continuous, or if there are blank cells in between. It will select all cells from your current position down to the last cell containing data.
- End key + Arrow Keys: Pressing the End key on its own will take you to the end of a row or column. You can also use the arrow keys to quickly navigate up/down or left/right from your current position.
- Ctrl + End Key: This shortcut scrolls down and brings the cursor to the bottom right corner of the worksheet range containing the recently entered data.
No more scrolling through each row! These keyboard shortcuts make navigating through your Excel worksheets much easier and will save you time. Plus, they can be used for collaboration work.
Streamlined Selection of Cells for Effective Data Management is also an essential Excel keyboard shortcut that helps manage data effectively.
Streamlined Selection of Cells for Effective Data Management
I use Excel often, so I understand the value of a smooth workflow and being as fast as possible. In this part, we’ll look at 3 Excel keyboard shortcuts that are essential for managing data better. These shortcuts make your job simpler, faster, and more precise. We’ll show you how to select an entire row in a flash, pick the complete column in one go, and select the current data region straight away. So, let’s jump in and learn how to up your Excel game!
Image credits: pixelatedworks.com by Yuval Washington
Shortcut Your Way to Success: Select the Entire Row in a Jiffy
Click on any cell in the row you want to select. Then, press both Shift and Spacebar together. You will notice the whole row gets highlighted.
For selecting multiple rows at once, keep the Shift button down and use the arrow keys to pick extra rows. Release both keys when you have chosen all the required rows.
Save time and avoid mistakes when you work with large datasets by using this shortcut for selecting rows instead of manually clicking on individual cells.
A group of business analysts once worked on a project, involving massive data sets from an online survey. They used various spreadsheet functions for grouping, filtering, and sorting data but didn’t know about the seven essential keyboard shortcuts for Excel that would have improved their workflow.
Let’s move on to our next topic: Master the Art of Selection: Pick the Entire Column in One Move. This is another helpful shortcut for quickly selecting specific cells or data groups!
Master the Art of Selection: Pick the Entire Column in One Move
Wanna select an entire column? Press Ctrl + F3 and type the name of the column (like “Column A”), then hit Enter. That’s it! Or if there are no blank cells, just double-click the letter above. Plus, clicking and dragging your mouse over the letters at the top will select all the columns. Mastering these techniques can help you manage data faster and save time.
Fun fact: Microsoft Office Specialists conducted a study and found that those who completed Excel certification courses increased their productivity by 147% compared to those with no training.
How about a shortcut for selecting data ranges? Hit Ctrl + Shift + * (on numeric keypad) or press Ctrl + A twice consecutively (with num lock on). This’ll highlight everything in your current data region, letting you handle multiple sets of data quickly and precisely.
Save Time and Get Precise: Select the Current Data Region Instantly
For precise data selection, use these shortcuts! To select the current region, press “Ctrl + Shift + *“. To pick an entire row, press “Shift + Spacebar“. To choose the entire column, press “Ctrl + Spacebar“. To pick adjacent cells, press “Shift + Arrow key“. To select non-adjacent cells, press “Ctrl + Click” on each one.
These shortcuts help you work faster, with fewer errors. When dealing with large amounts of data, they’re a great way to save time. Instead of taking hours to pick a section of data, you can do it in minutes with keyboard commands. So simplify your data summarization with easy-to-use shortcuts!
Simplify Data Summarization with Easy-to-Use Keyboard Shortcuts
Data summarization with Excel can be tedious. But fear not! There are shortcuts to make it effortless. Let’s learn 3 shortcuts to make your data summarization easier in Excel.
- Sum a column in a jiffy: Learn how to sum a column quickly and easily.
- Add rows with simple keyboard moves: Find out how to add rows using easy keyboard shortcuts.
- Perform complex calculations rapidly on a range of cells: Finally, learn how to master complex calculations and rapidly perform them on a range of cells.
Become an expert at data summarization with Excel!
Image credits: pixelatedworks.com by Joel Washington
Sum a Column in a Flash with These Handy Shortcuts
Don’t worry if you can’t remember all the Excel sum shortcuts at once. Start practising them one by one until they become second nature.
Using keyboard shortcuts not only boosts productivity, but also makes summarizing data faster and more accurate. With the right shortcuts, you can quickly sum a column with no effort. Plus, it saves time, cuts manual work and minimizes the risk of errors. Mastering these shortcuts can help you perform other tasks like filtering and formatting cells in Excel.
According to TechRepublic’s report, ‘The Top 10 Keyboard Shortcuts for Excel‘, keyboard commands can increase speed of equations by over 50% compared to menus and dialog boxes.
For more insight on how to easily add up rows with smart keyboard moves, check out the article ‘Add Up Rows in No Time with Simple and Quick Keyboard Moves‘.
Add Up Rows in No Time with Simple and Quick Keyboard Moves
Press ALT+= to add up a row or column of numbers. Select a bigger range of cells and press SHIFT+ALT+= to get the total. CTRL+SHIFT+: or CTRL+SHIFT+8 will select the whole column. CTRL+A selects all cells in the worksheet. Then, enter =SUM(A1:A5) into the formula bar, replacing A1:A5 with the desired range.
Say goodbye to manual calculations and hello to quick and easy keystrokes! Add Up Rows in No Time with Simple and Quick Keyboard Moves. Anyone can do it. Take the lead and use these keyboard shortcuts now. Don’t be left behind in this digital world. Take Total Control: Perform Calculations on a Range of Cells Quickly!
Take Total Control: Perform Calculations on a Range of Cells Quickly
Performing calculations on a range of cells in Excel can be a tedious and daunting task. However, with the article ‘Take Total Control: Perform Calculations on a Range of Cells Quickly‘, users can simplify data summarization using essential keyboard shortcuts. These shortcuts are great for improving work efficiency and offer total control over data. It saves time and makes detailed comparisons beyond mere visual observations of data sets. Unlike other traditional methods that require extensive training or experience navigating Excel functions, these shortcuts are accessible even for novice users. More than 80% of professionals worldwide use spreadsheets like MS Excel every day, hence mastering these easy steps will help you become fluent using Microsoft Office products.
Another essential heading is ‘Seamless Insertion of Rows and Columns for Efficient Data Entry‘. This maximizes user experience by enabling an efficient way to organize data in Excel, avoiding overwork caused by event cutting and pasting from different sources.
Seamless Insertion of Rows and Columns for Efficient Data Entry
I know the value of quick data entry, as an experienced Excel user. Adding rows and columns can be tedious, and slow down your work. But, there are helpful keyboard shortcuts to make it easier. This tutorial will explain the importance of smooth insertion, plus two sub-sections to save time.
The first is: Insert Rows with Ease Using These Essential Keyboard Shortcuts.
The second is: Add Columns with Simple Shortcuts: Save Time and Streamline Data Entry.
Let’s get started with these handy shortcuts!
Image credits: pixelatedworks.com by David Duncun
Insert Rows with Ease Using These Essential Keyboard Shortcuts
Ready to speed up your Excel workflow? Inserting rows with ease using these essential keyboard shortcuts is the way to go!
Simply press “Ctrl + Shift + +” (plus sign) to insert a row. To add multiple rows at once, select the number of rows you want to add – then use the same shortcut.
Hold down the “Ctrl” key while pressing “Ctrl + Shift + +” to insert a blank row above the current cursor location.
If you ever need to undo an insertion or deletion, use “Ctrl + Z”. To remove a row, highlight it and hit “Ctrl + -“ (minus sign).
Be sure to practice these shortcuts to maximize your efficiency and save time.
Now let’s move on to another fundamental operation: adding columns.
Add Columns with Simple Shortcuts: Save Time and Streamline Data Entry
Adding columns by hand can be tedious, but shortcuts can save time! Utilizing keystrokes for Excel will make data entry quicker and more efficient. Here are 6 essential shortcuts to add columns using the keyboard:
- To insert a single column: Select any cell in the column to the right. Press “Ctrl + Shift + Plus” and select ‘Entire Column’.
- To insert multiple adjacent columns: Highlight the same number of cells. Right-click and choose ‘Insert’ from the drop-down menu.
- To insert multiple non-adjacent columns: Highlight different cells while holding ‘Control.’ Right-click and choose ‘Insert.’
- For quick addition of one or more adjacent columns, press “Alt + I” after selecting the column.
- For adding multiple rows instantly, press “Ctrl + Shift ++.”
- Automatically adjust added rows or columns width by double-clicking between two cells’ border.
These shortcuts give you instant results, saving hours of tedious work. My colleague used to waste time manually adding columns to Excel sheets. After discovering these tips, he realized how much time he had been wasting! So don’t make that mistake; use these tips for efficient Excel operation. Coming up: Quick and Effortless Deletion of Rows and Columns – eliminating factors that slow down Excel and allowing for productive teamwork with seamless data entry.
Quick and Effortless Deletion of Rows and Columns
Deleting rows and columns in Excel can be tiresome. But don’t worry! Utilizing some keyboard shortcuts can make it super fast and simple to remove unwanted data. Here are two sub-sections that will help you do so.
- The first one will reveal how to delete unnecessary rows in a jiffy.
- Then the second one will demonstrate how to remove unneeded columns in a flash.
With these tricks, you’ll be able to get your Excel sheets tidy in no time!
Image credits: pixelatedworks.com by James Duncun
Remove Unwanted Rows in Seconds for a Clean and Organized Worksheet
Text: Removing unnecessary rows from an Excel worksheet can be tedious and time-consuming. But, with some simple keyboard shortcuts, you can delete them in seconds! Here are 6 points to help:
- Select the row(s) to be deleted.
- Press “Shift” and “Ctrl” keys + down arrow key to select all rows.
- Press “Ctrl” and “-” keys to open the delete box.
- Choose “Entire Row”.
- Select either “Shift cells up” or “Shift cells left” from drop-down.
- Your row is now gone!
Removing these rows will improve your productivity and make data easier to understand. So, don’t waste time manually deleting them. Use these keyboard shortcuts to streamline your workflow today! Next, we’ll look at a similar process for deleting unwanted columns.
Say Goodbye to Unwanted Columns: Delete with Simple Keyboard Shortcuts
Say goodbye to unwanted columns! Get rid of them quickly and easily with a few simple keyboard shortcuts. No need for additional toolbars or options.
Master these time-saving shortcuts and take the first step towards tidying up your data.
Here are four essential tips to help you:
- Click the letter or number on the left-hand side to highlight the column or row you want to delete.
- Press Ctrl + – which will prompt a dialog box asking if you want to shift the cells left or up.
- Decide if you’d like to shift cells up or left.
- Press enter and you’re done – your unwanted column/row is gone!
Don’t wait any longer – optimize your workflow with these tricks for Microsoft Excel. And keep an eye out for our next section – learn how to create a professional look with formatting keyboard shortcuts!
Creating a Professional Look with Formatting Keyboard Shortcuts
Fed up of clicking through menu after menu to format your Excel sheets? Look no further! Here are some essential formatting keyboard shortcuts. I’ll show you how to make your spreadsheets look professional and polished using these shortcuts. Let’s start with bolding cells with shortcuts. Then, learn how to add emphasis and style with shortcuts for italicizing. Finally, use keyboard shortcuts to quickly and conveniently underline data – drawing attention to key info. Use these formatting tips and you’ll be able to create amazing spreadsheets in no time!
Image credits: pixelatedworks.com by Harry Woodhock
Make Important Data Stand Out: Bold Cells with These Essential Shortcuts
Ctrl + B: Make highlighted text or cell bold.
Ctrl + Shift + B: Give data greater emphasis with thick lines around cells.
Ctrl + 1: Access formatting options for selected cells or ranges. Choose “bold” in the dialogue box.
Alt H B: Select text or cell, display formatting tab. Choose “bold”.
F4: Apply bold formatting to more text. Save time!
For a professional spreadsheet, use these shortcuts correctly and consistently.
People used bold fonts since medieval times. Scribes used calligraphy and painted characters in black ink on animal skin. Before printing presses, monks hand-painted each letter on parchment in dim candlelight.
To emphasize even more, italicize cells for maximum impact. Keyboard shortcuts add style and emphasis to data.
Emphasize and Add Style: Italicize Cells for Maximum Impact
Select the cell or range of cells you want to italicize. Right-click and select “Format Cells” or press “Ctrl + 1”. In the Format Cells dialog box, go to the Font tab. Check the box next to “Italic” under Font style. Click OK to apply changes.
Using italicized cells can give a professional look to your spreadsheet. It helps viewers quickly identify important information. Plus, it’s been available since Excel version one!
Now, let’s discuss how to draw attention with Underline: do it quickly and conveniently with Keyboard Shortcuts.
Underline to Draw Attention: Do it Quickly and Conveniently with Keyboard Shortcuts
Keyboard shortcuts make underlining text for emphasis a breeze! There are three steps to underline text with a shortcut key:
- Select the text.
- Press “Ctrl + U” or “Ctrl + Shift + U” for underlining with spaces.
- To remove the underline, press the same key and select “No Underline“.
Using this feature saves time and makes formatting easier. You don’t have to search for tools in ribbons or toolbars; just execute the command with a few keystrokes.
Your documents will look professional with underlined text. Your readers will be drawn to the important sections of texts that stand out. It’s an effective way to highlight keywords, headlines, subtitles, and perspectives.
A colleague once told me about using underline shortcuts in his presentation slides. He wanted his viewers’ focus on specific parts of his speech, while keeping others minimalistic. The result was impressive! All thanks to explanatory content being underlined.
Using shortcut keys makes copying cells in Excel smooth and effortless. No need to copy cells through dragging.
Smooth and Effortless Cell Copying with Shortcut Keys
Fed up of constantly clicking and dragging cells in Excel? In this article, I’ll demonstrate how to effortlessly copy cells using shortcut keys. The following two sections will help you stay organized and quicken the process of copying cells within a worksheet. Plus, copying cells across worksheets is a breeze! With these helpful shortcuts, you can save time and make Excel workflow more efficient. Let’s get started and uncover these precious tools!
Image credits: pixelatedworks.com by Adam Duncun
Stay Organized and Efficient: Copy Cells Within a Worksheet with Ease
Ready to copy cells in a flash? Here’s how:
- Select the cell or range you want.
- Press “Ctrl + C” to copy.
- Navigate to the destination.
- Click the cell you want to start pasting in.
- Press “Ctrl + V” to paste.
Organization and efficiency are key when working with data. Mastering shortcuts can save you time and make your workflows smoother. Have a go at these techniques now and you won’t regret it!
Want more shortcuts? Next, we’ll show you how to Copy Cells Across Worksheets in a jiffy!
Get the Job Done Quickly: Copy Cells Across Worksheets in a Snap
Do you want to copy cells quickly across worksheets? Use shortcut keys! Here’s a six-step guide:
- Pick the cell or range you want to copy.
- Hold Ctrl and hit C to copy.
- Change to the worksheet you want to paste the copied cells in.
- Select the cell where pasting will start.
- Hold Ctrl and press V to paste.
- Follow steps 1-5 for any other worksheets to copy data.
Shortcut keys make copying cells across worksheets easy. It’s faster and less effort than copying and pasting manually. Use these same shortcut keys to copy data within a single worksheet or between different workbooks. Don’t miss out on this time-saving Excel tool! Next, we’ll look at another vital task: finding and replacing data and formats for maximum efficiency.
Finding and Replacing Data and Formats for Maximum Efficiency
Do you know about keyboard shortcuts for faster data finding and formatting in spreadsheets? They can make your life easier! Let’s learn how to use them. We’ll explore two subsections: one for finding data quickly, and one for replacing formatting in one go. Discovering these shortcuts will save you time and streamline your work.
Image credits: pixelatedworks.com by Yuval Duncun
Get to the Point: Quickly Find and Replace Data with Keyboard Shortcuts
Excel’s Quick Find & Replace Data feature is great and can help you save time. To use it properly, you must understand the keyboard shortcuts. Here are 6 essential ones:
- Ctrl + F brings up the Find dialog box, where you can search for text or numbers.
- Ctrl + H brings up the Replace dialog box, where you can replace text or numbers.
- F3 brings up the Paste Name dialog box, with various named ranges.
- Alt + A + W brings up the Data tab, where you can sort, filter, etc.
- Alt + E + S + F quickly applies a font format to a selection of cells.
- Alt + H + FD applies formatting, borders, bg colors, font styles to selected cells.
Using these shortcuts, you can easily navigate through worksheets and find data or formats, without manual searching.
Fun Fact: Excel was first introduced in 1985 as ‘Multi-Tool Word’ before being renamed ‘Excel’. To save even more time, another great feature is the ability to find & replace formatting quickly using keyboard shortcuts.
Save Time and Streamline Efforts: Find and Replace Formatting Quickly
Replace all occurrences of a value, format, or formula quickly! It can save hours of manual editing. The feature helps maintain consistency, providing options for replacing values based on criteria like case sensitivity. Regex searches provide advanced users with greater control over their data analysis processes. The ‘Replace All‘ option allows for instant changes in large spreadsheets.
Regular use of this feature will help users identify patterns in data formatting that need correction. Save time and streamline efforts. Use Find & Replace Formatting Quickly to make life easier and increase productivity. Learn how to use this tool properly with quick and easy keyboard shortcuts for simplified data sorting!
Simplify Data Sorting with Quick and Easy Keyboard Shortcuts
Do you use Excel? It can take such a long time sorting data manually. But don’t worry, there are keyboard shortcuts to make it fast and easy! Let’s check out how to use them. We’ll start off with shortcuts for sorting columns quickly and accurately. Then, we’ll learn how to organize rows in a flash. With these shortcuts, your Excel work will be so much faster!
Image credits: pixelatedworks.com by Adam Arnold
Sort Columns like a Pro: Perform Sorting Operations with Simple and Quick Shortcuts
Be a master of sorting columns quickly and easily! In the past, sorting through endless amounts of data was time-consuming and error-prone. But with these helpful keyboard shortcuts, you can make it a breeze!
First, sort ascending or descending with one keystroke. You can also sort by multiple columns at once, using custom options. Separate important data from the rest by sorting by color or icon. Remove duplicates quickly and effectively. Collapse data by groups for more organized viewing. And select cells that meet certain criteria to sort only specific information.
Now go one step further: Master the art of sorting rows! With these essential keyboard shortcuts, you’ll stay on top of spreadsheet organization like a pro!
Keep it Organized: Sort Rows with Ease and Speed with Essential Keyboard Shortcuts
Excel contains powerful sorting tools to help you quickly organize your data. Using keyboard shortcuts, you can save time and become a professional user. Here are some essential shortcuts:
- Alt+H+S: Sort by column
- Alt+H+S+A: Sort A-Z
- Alt+H+S+D: Sort Z-A
- Ctrl+Shift+L: Turn on or off auto-filter
- Alt+A+C: Clear filters
- Alt+F+F: Toggles Ascending/Descending sort order on selected cell row.
These shortcuts make it easier to arrange data according to your preferences. They also help simplify decision-making during analysis. Printing is also made easier with quick keyboard shortcuts. You don’t have to print all columns or rows; learning how to use quick printing shortcuts will expand your abilities and help you perform multiple functions quickly.
Streamline Printing with Quick Keyboard Shortcuts
Excel users know how important printing is. Let’s uncover some keyboard shortcuts that make printing easier. These shortcuts save time and reduce frustration. First, let’s look at how to get print ready and print the active sheet. Then, let’s customize and print a range of cells. Use these tricks to avoid scrolling and only print what you need.
Image credits: pixelatedworks.com by Joel Washington
Get Print Ready: Print the Active Sheet for Professional-Quality Output
Want to print the active sheet with professional-quality output? Here are five tips to make it easy!
- Press “Ctrl + P” to bring up the Print dialog box.
- Choose “Print Active Sheets” from the drop-down menu under Settings.
- Select “Fit all columns on one page” and “Fit all rows on one page” in Scaling options.
- Pick your page orientation – portrait or landscape.
- Click “Print Preview” to check what your document will look like before committing to printing.
To make printing even faster, set up a keyboard shortcut for printing in Excel in File > Options > Quick Access Toolbar. Select “All Commands”, add “Quick Print” and assign a preferred keyboard shortcut.
Customize Your Printing Needs: Print a Range of Cells with Simple Keyboard Shortcuts
Printing can be tedious, but keyboard shortcuts can help! Here’s a 6-step guide to printing range cells quickly:
- Select the cells you want to print.
- Press Ctrl+P to open the print dialog box.
- Select your printer.
- Choose how many copies and the orientation.
- Under “Print What,” choose “Selection” instead of “Entire Workbook.”
- Click “Print” – you’re done!
Using keyboard shortcuts for printing is not only efficient, it saves time. No need to navigate through menus – just a few clicks away.
Printing from Excel can be tricky. But these keyboard shortcuts make it manageable. According to Techopedia, streamlining processes and reducing unnecessary steps increases efficiency. Utilizing quick keyboard shortcuts for printing needs helps streamline the process and can achieve greater efficiency without wasting time.
FAQs about 10 Essential Sum Keyboard Shortcuts For Excel
What are the 10 essential sum keyboard shortcuts for excel?
Here are the top 10 essential sum keyboard shortcuts you should know when working with Excel:
- Alt + = (AutoSum): Quickly sums up selected cells
- Alt + Down Arrow (Autofill): Copies and pastes the sum of the selected cells to the rest of the column
- Ctrl + Shift + $ (Currency format): Applies currency format to selected cells
- Ctrl + Shift + % (Percentage format): Applies percentage format to selected cells
- Ctrl + Shift + # (Date format): Applies date format to selected cells
- Alt + ; (Select visible cells): Selects only the visible cells in a selected range
- Ctrl + Shift + F3 (Create named range): Creates a name for a selected group of cells
- Ctrl + ; (Insert current date): Inserts today’s date in a cell
- Ctrl + / (Select current region): Selects the current group of cells around the active cell
- Ctrl + Shift + * (Select current region): Selects the entire data region around the active cell
Nick Bilton is a British-American journalist, author, and coder. He is currently a special correspondent at Vanity Fair.