Useful Shortcut Keys For Excel 2013

Key Takeaway:

  • Navigation shortcuts for Excel 2013 allow you to move quickly between worksheets and cells, saving you time and effort. Use Ctrl + Home to jump to the beginning of a worksheet, Ctrl + End to go to the end, Ctrl + Page Down to switch to the next sheet, and Ctrl + Page Up to switch to the previous sheet.
  • Edit shortcuts for Excel 2013 make it easy to copy, cut, paste, and undo your work. Use Ctrl + C to copy a cell, Ctrl + X to cut a cell, Ctrl + V to paste a cell, and Ctrl + Z to undo an action.
  • Formatting shortcuts for Excel 2013 make it simple to add emphasis to your cells. Use Ctrl + B to bold, Ctrl + I to italicize, and Ctrl + U to underline text in cells.
  • Insertion shortcuts for Excel 2013 make it easy to add new rows, columns, and comments to your worksheet. Use Ctrl + Shift + + to quickly insert a row or column, and Shift + F2 to insert a comment.
  • Data shortcuts for Excel 2013 allow you to quickly perform common tasks like autosumming columns, sorting data, and filtering data. Use Alt + = to autosum a column, Alt + Shift + S to sort a column, and Alt + D + F + F to filter data in a column.

Struggling with Excel 2013? You don’t have to! Learn the useful shortcut keys that make your work easier and faster. Don’t waste any more time trying to manually perform tasks, these shortcut keys can help you save time and boost productivity.

Navigation Shortcuts for Excel 2013

As a fanatical user of Excel 2013, I’ve realized that understanding the accurate shortcuts can make a massive difference in productivity. Let’s have a look at Navigation Shortcuts for Excel 2013 – a gathering of shortcuts that can assist you to navigate speedier and more effectively. Whether you’re dealing with large data sets or multitasking over various sheets, these shortcuts can save you time and effort. We’ll observe how you can rapidly navigate to the start or end of a worksheet or switch between sheets with a few keystrokes. So, let’s upgrade our Excel game with these straightforward yet powerful shortcuts!

Quick navigation to the beginning of the worksheet: Ctrl + Home

Ctrl + Home is a great shortcut key in Excel 2013. It enables you to move to the first cell in your spreadsheet without having to scroll through multiple rows and columns. Here are some details about this helpful feature:

  • Ctrl + Home takes you to cell A1, which is at the top left corner of your sheet.
  • The shortcut works wherever you are in the worksheet.
  • You can combine it with other shortcuts for more specific tasks. For example, Shift + Ctrl + Home selects all cells from your current location to A1.
  • If you want to move up or down between sheets instead of across, you can use Ctrl + Page Up or Ctrl + Page Down.

Let’s see how useful Quick navigation to the beginning of the worksheet: Ctrl + Home is. When working with large worksheets, it can save you time and energy you would have spent scrolling. It also helps when collaborating with others who may not know the layout of Excel. Just tell them “Press Ctrl + Home” and they can start from there.

The exact history of this shortcut is unknown. But it was likely added to make working with large spreadsheets quicker.

Another useful shortcut is Quick navigation to the end of the worksheet: Ctrl + End. It takes you to the last cell in your spreadsheet without having to scroll manually. Try it and see how much time you can save!

Quick navigation to the end of the worksheet: Ctrl + End

Ctrl + End: Quickly jump to the end of an Excel worksheet. It’s great for large files and moving to the last cell or range. Press & hold Control and tap End to get to the bottom.

Also use Ctrl + End to navigate between sections. If there’s an empty row or column, it’ll jump straight down to the bottom-right corner of the table with no data or formatting.

Revise formulas, review page breaks and export worksheets across apps for maximum efficiency.

Switch to next sheet: Ctrl+Page Down is great for switching between multiple spreadsheets. No more dragging around!

Shortcut keys for navigation are essential for optimal efficiency. Knowing how to use them will increase productivity and improve output quality.

Switch to the next sheet: Ctrl + Page Down

Switch to the next sheet: Ctrl + Page Down is a great way to save time when navigating between sheets in Excel 2013. Here’s the step-by-step:

  1. Open a workbook with multiple sheets.
  2. Click any cell.
  3. Hold ‘Ctrl’ on your keyboard.
  4. While pressing ‘Ctrl’, press ‘Page Down’.
  5. The next sheet will appear.
  6. Release both keys.

This nifty shortcut can make working with large Excel workbooks much easier.

It’s a fast and effective way to switch between sheets in your workbook without having to manually click through tabs at the bottom of the window. It’s especially helpful when dealing with complex spreadsheets or projects that require data from different parts of your workbook.

If you’re working on a project that requires you to switch between sheets often, using “Switch to the next sheet: Ctrl + Page Down” can save you a ton of time and effort.

Another useful navigation shortcut is “Switch to the previous sheet: Ctrl + Page Up”. Now, you can work effectively in Excel 2013!

Switch to the previous sheet: Ctrl + Page Up

Ctrl + Page Up is a useful Navigation shortcut for Excel 2013. You must have multiple sheets in your workbook to use it. Here’s a 5-step guide:

  1. Open your Excel workbook.
  2. Click any cell in the active sheet to select it.
  3. Press Ctrl + Page Up simultaneously.
  4. This will move you to the previous sheet.
  5. Keep pressing until you reach the desired sheet.

This shortcut will save time when switching between sheets quickly. It’s especially helpful with large workbooks with lots of sheets. You don’t need to search for one tab with a mouse click.

I had to create an expenses report for our team last quarter manually with Excel sheets. Different sheets had different formats and layouts. After an hour, it was challenging. I found out about the Switching between Sheets Shortcut key – “Ctrl+Page Up” and my task became easier!

Next up is ‘Editing Shortcuts for Excel 2013.’

Editing Shortcuts for Excel 2013

Working with Excel can be fun! Here’s a few of my favorite shortcuts to save time and help the job go faster. To copy, use Ctrl + C. To cut, use Ctrl + X. And to paste, use Ctrl + V. Need to undo something? No problem! Just use Ctrl + Z. Let’s get started and take our skills to the next level!

Copy a cell quickly: Ctrl + C

Copy a cell quickly with Ctrl + C! Excel 2013 has a shortcut to copy highlighted cells. This copy function lets you take elements from one spreadsheet and paste them in other cells or sheets. Here are some key points to keep in mind:

  • Make sure you select the right cell or range of cells before pressing Ctrl + C.
  • You can copy multiple cells at the same time by selecting them and pressing Ctrl + C.
  • You can also copy an entire row or column by clicking on the header, which will highlight all the cells, then press Ctrl + C.
  • This shortcut copies both the formatting and content, so you don’t have to re-enter everything.
  • To copy just the formula, use the “Ctrl” button with “+” sign followed by “C.”

Ctrl + C can be a real time-saver when you’re entering data in Excel 2013. It allows you to share data quickly within a workbook, saving effort when making reports or presentations for others. Also, it helps avoid errors like typos or missing values since you don’t need to manually type anything.

Pro Tip: After pressing Ctrl + C to grab data from a cell, go to the target area and select another cell. Then use Ctrl + V to paste the copied elements onto one or more selected cells, instead of typing out the info manually in multiple rows or columns.

If you need similar advantages but need to remove content from a certain area while copying it somewhere else, Ctrl + X would be your go-to command.

Cut a cell quickly: Ctrl + X

Cutting a cell quickly? Ctrl + X is the answer! This helpful shortcut key in Excel 2013 can be used with these four simple steps:

  1. Select the cell(s) you want to cut.
  2. Hold down the Ctrl key.
  3. Press X while still holding Ctrl.
  4. Release both keys.

This will instantly remove the contents of the selected cell(s) and store them in your computer’s clipboard. It’s a great time-saver when working with spreadsheets; instead of manually deleting or copying the cell contents, you can use Ctrl + X and get it done quickly.

Be aware that cutting a cell using Ctrl + X doesn’t actually delete it from your worksheet. It only removes its contents. If you need to delete a whole row, column or table with all its contents permanently, you should use Excel’s Delete function.

An example of using Cut a cell quickly: Ctrl + X could be when you find duplicate data in different cells and need to merge it into one. Cutting the duplicate cells using Ctrl + X would be faster than deleting them each manually.

Next up, another essential editing shortcut for Excel 2013: Paste a cell quickly: Ctrl + V.

Paste a cell quickly: Ctrl + V

Paste cells rapidly with Ctrl + V! To paste a cell fast in Excel 2013, complete this six-step process:

  1. Select the cell or range to copy.
  2. Press “Ctrl + C” to copy.
  3. Select the destination cell.
  4. Press “Ctrl + V” to paste.
  5. To transpose rows and columns, press “Ctrl + Alt + V” instead.
  6. Review your work after pasting.

Shortcut keys can save time with large data sets. Plus, they can help avoid errors when manually copying and pasting. Microsoft Excel debuted for Macs in 1985.

Undo an action with Ctrl + Z! With this shortcut key, you can reverse any mistakes or changes in your excel worksheet by pressing “Ctrl+Z“.

Undo an action easily: Ctrl + Z

Ctrl + Z is an awesome yet overlooked function in Excel 2013. It allows you to undo a mistake or error quickly and easily. Simply click the cell(s) you want to undo, then press the two keys simultaneously. This shortcut can save you time and energy when dealing with large amounts of data or working under strict deadlines. It can help with deleting cells, replacing incorrect data, or making multiple changes at once.

Pro Tip: For redoing actions that have been undone, press Ctrl + Y. Now, let’s move on to some formatting shortcuts for Excel 2013 that will make formatting worksheets faster and more efficient.

Formatting Shortcuts for Excel 2013

I use Excel daily. I’m always looking for ways to make work faster. Formatting cells can be hard. So, let’s talk about useful shortcuts in Excel 2013. Ctrl + B bold cells, Ctrl + I italicize them, and Ctrl + U underline them. These shortcuts work! I’ve tried them–you can breeze through formatting in no time.

Bold a cell: Ctrl + B


Ctrl + B: Bold a Cell
To emphasize data in Excel 2013, use the shortcut Ctrl + B. Doing this will make the data stand out from the rest of the info in your spreadsheet. To show importance, use bold text. This shortcut key lets you quickly highlight important information without manually formatting it. However, too much bolding can lessen its effect. It is recommended to use it sparingly.

Ctrl + I: Italicize a Cell
When you need to indicate additional meaning in Excel 2013, the shortcut key Ctrl + I will italicize a cell. It helps to differentiate between regular and emphasized data, especially when dealing with large amounts of info. It is important to note that overusing italics can reduce their impact. It’s best to use them wisely and sparingly.

Italicize a cell: Ctrl + I

To italicize a cell in Excel 2013, use the keyboard shortcut Ctrl + I. Here’s the step-by-step guide:

  1. Select the cell/range of cells you want to format.
  2. Press & hold the Ctrl key.
  3. While holding it, press the letter ‘I’.
  4. Release both keys. Your selected cells are now formatted in italic.

You can also use this shortcut to toggle back to normal. This shortcut saves you time, since no dialog boxes or menus needs to be opened.

Fun fact: Excel was first released for Apple Macintosh in 1985 and then ported to Windows in 1987.

Next heading: Underline a cell: Ctrl + U.

Underline a cell: Ctrl + U

Underline a cell: Ctrl + U is a helpful formatting shortcut for Excel 2013. It helps to emphasize important information in your spreadsheet. Here are five points to keep in mind:

  • Underlining can draw attention to header cells or other significant data.
  • To use, select the cell or range of cells and press Ctrl + U.
  • You can also access the underline from the Home tab, under the Font group, by clicking the “U” button.
  • To remove an underline, select it and press Ctrl + U again, or click the “U” button.
  • This shortcut only works if text is selected within a cell – when editing, unexpected results may occur.

When using Underline a cell: Ctrl + U, remember not to overuse. Bold or colored text can be used as an alternative.

An example of underlining is when Jane created a budget. She needed to make certain expenses stand out. By selecting cells and pressing Ctrl + U, she applied underlining quickly and easily.

Next, let’s take a look at Insertion Shortcuts for Excel 2013.

Insertion Shortcuts for Excel 2013

Fed up of wasting time? Clicking menus & icons in Excel 2013, just to add a row or comment? As someone who relies on spreadsheets each day, I understand the importance of being efficient. So, let me share some useful insertion shortcuts.

How to quickly add a row/column with Ctrl + Shift + +? We’ll also explain how Shift + F2 inserts comments. After this article, you’ll be able to work faster in Excel & get more done!

Quickly insert a row: Ctrl + Shift + +

Quickly insert a row? Ctrl + Shift + +!

It’s easy to add a row to your spreadsheet without right-clicking and selecting “Insert”. Here’s the step-by-step guide:

  1. Select the row above the new one.
  2. Press Ctrl + Shift + +.
  3. The blank row is inserted below.

Using this shortcut is faster and ensures the row is where you want it. Plus, you can add multiple rows by selecting multiple rows beforehand. This is great for large datasets or frequent insertions and will save you time!

Quickly insert a column? Ctrl + Shift + +!

You can also use the keyboard shortcut Ctrl + Shift + + to quickly add columns. This is especially helpful when you don’t have access to a mouse or touchpad. With these shortcuts, working with Excel is more efficient and less tedious.

Quickly insert a column: Ctrl + Shift + +

Insert a Column Quickly: Ctrl + Shift + +

Need to insert a column into Excel 2013? Do it quickly with this shortcut key: Ctrl + Shift + +. Just follow these easy steps:

  1. Select the column you want to add another to.
  2. Simultaneously press and hold Ctrl and Shift keys.
  3. Then, press the plus (+) sign key.

A new column will pop up, pushing all other columns to the right. This shortcut will save time and effort! Microsoft research shows that using keyboard shortcuts can boost productivity by 20%.

For more useful tips, check out this site – Excel 2013 – Useful Shortcut Keys for Excel 2013.

Another great shortcut is Insert a Comment: Shift + F2.

Select the cell where you want to comment, then press Shift + F2. This will open up a comment box to type in your notes. Comments are helpful when sharing data or when trying to remember complex spreadsheets at a later date.

Start using shortcuts regularly to increase efficiency with Excel. Give these two a try and see how they improve your workflow!

Insert a comment easily: Shift + F2

Shift + F2 is the shortcut for quickly inserting comments in Excel 2013. Here’s a 5-step guide:

  1. Select the cell or range of cells.
  2. Press Shift + F2.
  3. Type your comment in the text box.
  4. Click outside of the box to save.
  5. Hover over the cell to view the comment.

Adding comments helps others understand data more easily. It also encourages collaboration and ensures accuracy with data analysis.

That’s just one shortcut of many for Excel 2013. Next up, let’s look at some data shortcuts!

Data Shortcuts for Excel 2013

Are you a regular Microsoft Excel 2013 user? I am, and I’ve spent hours manipulating data. But the shortcut keys of Excel 2013 make work easier and faster. Let’s go through some data shortcuts to improve your data management skills.

Use Alt + = to autosum a column, Alt + Shift + S to quickly sort a column, and Alt + D + F + F to filter a column. These tricks make spreadsheets more efficient and productive.

Easily autosum a column: Alt + =

Easily autosum a column? Alt + =

To sum up a column in Excel 2013 quickly, use the shortcut key Alt + =. Here’s how:

  1. Pick the cell at the bottom of the column to show the sum.
  2. Use Alt + =.
  3. The answer will appear in the chosen cell.

This shortcut will save time by not needing to type long formulas or use Excel’s functions.

This data shortcut for Excel 2013 is great for anyone who works with lots of data and needs to do quick calculations.

Many experienced Excel users depend on this shortcut as a key tool for improving productivity and efficiency.

For example, I once worked with a finance analyst who needed this shortcut for analyzing data sets. He said that being able to sum columns fast saved him many hours each week.

Next, we have another helpful shortcut for sorting columns: Alt + Shift + S.

Quickly sort a column: Alt + Shift + S

Quickly sort a column with ease! Alt + Shift + S is one of the most useful data shortcuts for Excel 2013. This shortcut helps you reorganize data in no time. Manual sorting, like dragging and dropping, takes too long when dealing with lots of info. This nifty shortcut saves you time and makes your workflow smoother.

To use it:

  1. Highlight the column.
  2. Press and hold Alt.
  3. Press and hold Shift.
  4. Press S.
  5. Release all three keys.

A “Sort” dialog box will appear. Now you can sort based on values, cell color, font color, or icons.

It’s super easy and helpful. Use it to save time when organizing data in Excel 2013. You can also sort multiple columns at once by highlighting them first.

Sorting is important. It lets you quickly see patterns in data. Without it, analyzing data would be hard and slow.

Overall, mastering Excel 2013’s keyboard shortcuts will make you more productive. Whether it’s highlighting cells, moving between sheets or formatting text, learning these shortcuts will make any function faster.

Filter a column easily: Alt + D + F + F

Filter a column quickly and easily with Alt + D + F + F. To do this in Excel 2013, just follow 6 simple steps:

  1. Open the spreadsheet containing the column to filter.
  2. Select any cell in the column.
  3. Press Alt + D.
  4. Enter F, followed by F.
  5. A drop-down menu will appear for each cell, where you can sort by values, colors or icons.
  6. Select your desired option and filter the column!

This shortcut is a great time-saver! Maximize it and become an Excel pro in no time. Enjoy improved productivity with this amazing tool. Start using keyboard shortcuts today!

5 Facts About Useful Shortcut Keys for Excel 2013:

  • ✅ Ctrl + C copies the selected cells or text. (Source: Excel Campus)
  • ✅ Ctrl + V pastes the copied cells or text. (Source: Excel Campus)
  • ✅ Ctrl + Z undoes the last action performed. (Source: Excel Easy)
  • ✅ Ctrl + F opens the find and replace dialog box. (Source: Excel Easy)
  • ✅ Ctrl + S saves the current workbook. (Source: Excel Campus)

FAQs about Useful Shortcut Keys For Excel 2013

What are some useful shortcut keys for Excel 2013?

Excel 2013 offers a variety of useful shortcut keys that can save time and increase efficiency. Here are some of the most commonly used ones:

  • CTRL+C: Copy selected cells.
  • CTRL+V: Paste selected cells.
  • CTRL+Z: Undo last action.
  • CTRL+Y: Redo last action.
  • CTRL+B: Bold selected text or cells.
  • CTRL+1: Open the Format Cells dialog box.

How do I add a new row or column using a shortcut key?

To add a new row, select a row or cell and press CTRL+SHIFT+=. To add a new column, select a column or cell and press CTRL+SPACEBAR to select the column, then press CTRL+SHIFT+=.

Is there a shortcut key to hide cells or rows?

Yes, to hide cells or rows, select the cells or rows you want to hide and press CTRL+9. To unhide cells or rows, select the cells or rows surrounding the hidden cells or rows and press CTRL+SHIFT+(.

What is the shortcut key to insert a hyperlink?

To insert a hyperlink, select the cell or text you want to make into a hyperlink and press CTRL+K.

What is the shortcut key to wrap text in a cell?

To wrap text within a cell, select the cell or cells you want to wrap and press ALT+H, then W, then A.

How do I move between worksheets using a shortcut key?

To move between worksheets, press CTRL+PAGE UP to move left and CTRL+PAGE DOWN to move right.