Top-rated Website Design, Development & SEO Company in Jaipur
Best Tricks To Speed Up Your Excel Work
SEO

Best Tricks To Speed Up Your Excel Work

Nowadays excel is used by almost everyone according to their needs or work Preferences. Some of them are used for preparing Seo Excel Sheets, hospital data, schools, and so on. So today I mention some of the tricks that will speed up your excel works

CTRL + Enter: Same Data In Multiple Cells

If you need to enter the same data into various cells, this function allows you to do it incredibly quickly.

CTRL + Right arrow : Move Right

Essentially, these pages right in your Excel worksheet.

CTRL + A : Select All

If you are frustrated with your worksheet and just and to start over, use this shortcut to select all and delete. When the frustration abides and you want all your work back, just hit CTRL + Z and your job will be saved.

CTRL + H : Find&Replace

If you misspelled a word or just want to replace something with a new something, the find and replace function is the best way to go about it.

CTRL + Left arrow : Move Left

This does the same thing as the page right above, except it pages left.

Shift + Spacebar: Select The Entire Row

If you are working in a cell and realize you need to select the entire row that cell is in, hitting this Excel shortcut will automatically select the row. You can then delete the entire row or make whatever changes you think are necessary.

CTRL + Shift + #: Change Date Format With Day, Month, And Year

This shortcut quickly gives you access to the default date format.

CTRL + ` : Display Formulas

By using this Excel shortcut you can quickly switch between displaying a cell’s formula and its values in a snap.

ALT + H + O + I : Autosize Columns

This shortcut functions as more of a sequence. First press Alt + H to navigate to the home tab. Then type O to select the format menu (while still holding Alt). Then type I to autofit the column width.

F2: Edit Selected Cell

By pressing F2, Excel will enter cell edit mode with the cursor at the end of the cell. A hand shortcut for making quick changes.

F4: Repeat Last Edit

Pressing F4 will repeat your last action or edit. If you want to repaste something again or repeat a formula insert, this key will save time.

ALT + = : Automatically SUM() Selected

If you have a block of data and you want to add all of the columns and the rows, using this command will Autosum the data and put all of the equations in one swoop. Make sure you include a spare column on the right and a spare row on the bottom for the summation data.

PG + UP: Go To Next Worksheet

This command switches worksheet tabs to the right.

PG + DOWN: Go To Previous Worksheet

This command switches worksheet tabs to the left.

CTRL + K: To Insert Hyperlink

First, you need to select where you want a hyperlink to appear. Then press these keystrokes and the insert hyperlink box appears, making the process that much easier.

CTRL + B : Bold

Use this to quickly bold or unbold a cell or text.

CTRL + U : Underline

Use this to quickly underline or un-underline a cell or text.

CTRL + Shift + @ : Time Style

This shortcut will give you quick access to the time of day style and allow you to add it into a cell.

CTRL + Shift + ~ : General Style Number

This command styles your cell to a general style number.

CTRL + Shift + ^ : Scientific Notation Style

Working with a big number? Use this shortcut to quickly convert to scientific notation. This useful for all of us engineers out there.

CTRL + Shift + ! : Number Style

Using this will give you access to a cell number style.

CTRL + [: Select All Cells Directly Referenced By Formulas In The Selection

This shortcut is especially useful in excel worksheets that have seemingly endless formulas. If you quickly want to see what cells are referenced in another cell, use this Excel shortcut to see them. Of all of the shortcuts, this one I use the most as it keeps me from having to look through a formula and see what is referenced where.

CTRL + A : Select All

If you are frustrated with your worksheet and just and to start over, use this shortcut to select all and delete. When the frustration abides and you want all your work back, just hit CTRL + Z and your job will be saved.

CTRL + Right arrow : Move Right

Essentially, these pages right in your Excel worksheet.

CTRL + Left arrow : Move Left

This does the same thing as the page right above, except it pages left.

CTRL + Up arrow : Move Up

Use this function to page up in a worksheet.

CTRL + Down arrow : Move Down

Use this function to page down in a worksheet.

CTRL + ; : Insert Actual Date In Active Cell

Can’t get a date? Hit this shortcut to get one quickly. (Only works in Excel, not real life)

CTRL + : : Insert Actual Time In Active Cell

Need to remember right when you input some data into your spreadsheet? Using this function will place the exact current time in a cell of your choosing.

CTRL + Shift + J : List Constants

Hitting this will list your properties/methods/constants within a worksheet.

ALT: Access the ribbon for formulas

Pressing the ALT key makes small letters appear on the toolbar ribbons. These are called KeyTips which will help you navigate the ribbons using only your keyboard.

ALT + Enter: Start a new line in the same cell

This shortcut is handy for those of us who need to put a lot of data into one cell. It essentially functions as a line break inside of a cell. If you need to write a large paragraph inside a worksheet, knowing this function is essential.

CTRL + ALT + F9 : Calculates All Worksheets

Using this Excel shortcut force calculates all worksheets that have open workbooks.

CTRL + Backspace : Show Active Cell

If you have absolutely no idea where the active cell your working on is because you scrolled so far, this one is for you. Pressing CTRL + Backspace will quickly navigate your window right back to the active cell.

F11: New Chart

Using F11 is a handy and quick way to create a new chart without having to navigate through Excel’s native toolbars. When you have data selected and press F11, a default chart will automatically appear with the selected data inside.

CTRL+ Shift + $ : Applies The Currency Format To the selected cells

If you quickly want to change a cell to the currency format, you can select it and hit this shortcut. It will apply to multiple cells as well if you have them selected.

CTRL + Shift + & : Applies Border To Eells

Instead of navigating through endless menus, use this Excel shortcut to quickly add borders to the cells you have selected. Borders are generally a good idea to use if you want to organize your worksheet and make it more professional.

CTRL + I : Italics

Use this to quickly italicize or un-italicize a cell or text.

CTRL + Shift + % : Percentage Style Number

This command styles your cell to a percentage style number. Make sure your original number has the right number of decimals. If you want 20 percent, you will need to have .2 in the cell before formatting.

CTRL + F12 : Open

Forgot that the data you needed was in another workbook? Hit this shortcut and quickly navigate to opening another file.

CTRL + F : Find

Forgot where you put that crucial piece of data, use this shortcut to quickly find it.

Hope You Really Like It And Find it Useful Too… IF Yes Then Do SHARE !!

27 thoughts on “Best Tricks To Speed Up Your Excel Work”

  1. OMG what a perfect post! This is something I need as I tend to forget. I wish I knew more of these shortcuts while I was in university.

  2. This info is so timely. I’m working on a spreadsheet right now. Thank you for sharing this! It’s very helpful.

  3. I’ve been using Excel since the 90’s. I do know most of the keyboard tricks. However, it looks like some I didn’t know were in here. My husband is always asking me about keyboard shortcuts. I’m sending him this article.

  4. WHAT. A. USEFULL. POST.
    While I was reading I opened my excel and tried everything! Thank you so much I’m always struggling with excel!

  5. These are great tricks for sure! I haven’t used Excel in so long I know I would need these and a few more just to get anything done!

  6. These tips are so helpful!!! Excel is not my favorite program but I’m always looking to learn more about it.

  7. I don’t ‘use excel much, but it’s definitely useful for me from time to time. These are some great shortcuts. Need to have this bookmarked and handy!

  8. You have no idea how helpful this is!! I haven;t used excel in years and Ive recently had to start but I have no idea what i’m doing! This is going to be my cheatsheet!

  9. Omg! Where have you been all my life! I almost quit my current job because of excel driving me nuts! I deal with it on a daily basis! Lol. THANK YOU!

  10. wow! very cool and helpful tips/tricks. will implement them any time am using excel. Thanks for the post.

  11. It’s really a nice and helpful piece of information. I am satisfied that you just shared this useful info with us.
    Please keep us informed like this. Thank you for
    sharing.

  12. Thanks a lot for sharing this with all people you actually recognize what you’re talking approximately! Bookmarked.

  13. Amazing things here. I’m very happy to look your post. Thanks a lot and I’m having a look
    forward to touch you. Will you please drop me a e-mail?

  14. Every weekend i used to go to see this web site, as i want enjoyment, for
    the reason that this this website conations truly fastidious funny stuff too.

  15. Nice post. I learn something new and challenging on websites I stumbleupon everyday.
    It will always be useful to read content from other authors and use a little something from other web sites.

  16. I was suggested this website by my cousin. I am not sure whether this post is written by him as nobody else know such detailed about my problem. You’re wonderful! Thanks!

  17. I’m also writing to let you be aware of what a helpful encounter my cousin’s child gained studying your web site.
    She came to find so many issues, not to mention what it’s like to possess a wonderful helping heart to make others completely
    thoroughly grasp various complicated topics. You actually exceeded
    readers’ desires. Many thanks for distributing these great,
    healthy, informative, and fun guidance on this topic.

  18. Your style is so unique compared to other folks I’ve read stuff
    from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just
    book mark this site.

Leave a Reply

Your email address will not be published. Required fields are marked *