{"id":91706,"date":"2017-05-23T15:47:04","date_gmt":"2017-05-23T15:47:04","guid":{"rendered":"http:\/\/sftarticles.wpenginepowered.com\/en\/?p=91706"},"modified":"2025-07-01T23:52:20","modified_gmt":"2025-07-02T06:52:20","slug":"these-5-excel-tips-and-tricks-will-save-you-time","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/these-5-excel-tips-and-tricks-will-save-you-time\/","title":{"rendered":"These 5 Excel Tips and Tricks Will Save you Time"},"content":{"rendered":"

Microsoft Excel can seem like your best friend or worst enemy at times. It has so much to offer the regular user but at times Excel\u2019s features can seem like they\u2019re hiding behind an impregnable wall made of white bricks.<\/p>\n

With this in mind and to\u00a0help anybody who uses Excel regularly, we\u2019ve put together our 5 favorite time saving tips. These handy tips will give you a bit more control over your spreadsheeting and will save you some time in the process. Once you\u2019ve gone through these tips make sure you check out our other Excel tricks at the bottom of the page.<\/p>\n

\u00a0Excel Power User\u2019s Favorite Tips<\/h2>\n

F4 to Repeat Processes<\/h4>\n

A great way to save time in Microsoft Excel is to use the F4 key to Repeat Processes. This can be used for repeating all sorts of different processes like changing the font of a selected amount of text or deleting the same amount of data again.<\/p>\n

\"These
Here I select 1 cell and change the font to Aharoni<\/figcaption><\/figure>\n
\"These
After selecting a number of other cells and pressing F4, the font in all of those cells is then changed to Aharoni also<\/figcaption><\/figure>\n

Make Charts Fit to cells<\/h4>\n

Adding charts to your spreadsheets is a great way to visualise the date your collecting. If you want to to make them more professional, however, by by aligning them to the ceells of the spreadsheet you can end up wasting precious time. To avoid this, simply hold the Alt key whilst adjusting the size of your chart<\/strong> and it will automatically fit the nearest cells around it.<\/p>\n

Duplicate a formula exactly<\/h4>\n

A common trick on Excel is to drag the corner of a cell containg a formula and have the formula recreated in the corresponding cells but with updated cell references. If, however, you’d like to copy the exact formula all you have to do is go to the cell directly below the one containing the formula and press Ctrl and ‘<\/strong>.<\/p>\n

Insert the Time and Date<\/h4>\n

It isn’t hard to think of a time when you might need to add the time and date to a spreadsheet that you’re working on. To add the current system date to your spreadsheet all you have to do is press Ctrl and ;<\/strong>. Then if you’d like to add the current system time simply press Ctrl and Shift and ;<\/strong>.<\/p>\n

\"These
The quickest and easiest way to add the current time and date to your spreadsheets<\/figcaption><\/figure>\n

Edit Cells Using F2<\/h4>\n

If you’ve already lots of data to your spreadsheet and you need to edit it you might not have time to click on each cell you need to edit and then move your hand from the mouse to the keyboard to begin editing. If you want to begin editing of any cell you’ve selected using the arrow keys on the keyboard you only have to press F2.<\/strong> You won’t believe how much time this will will save you.<\/p>\n

There you have it then. 5 simple tips that’ll help you save time whilst using Microsoft Excel. If you want more Microsoft Excel tips make sure you check some of the these other great Softonic articles.<\/p>\n

\n
\n
\n
\n

10 extremely useful templates for Excel that might save your life<\/a><\/h4>\n

10 games for Microsoft Excel?! And free?!<\/a><\/h4>\n

Office Tip: how to freeze and lock multiple Excel cells<\/a><\/h4>\n

10 essential Excel formulas: become an Excel pro<\/a><\/h4>\n
<\/div>\n<\/div>\n<\/article>\n<\/div>\n<\/div>\n

<\/h4>\n","protected":false},"excerpt":{"rendered":"

Microsoft Excel can seem like your best friend or worst enemy at times. It has so much to offer the regular user but at times Excel\u2019s features can seem like they\u2019re hiding behind an impregnable wall made of white bricks. With this in mind and to\u00a0help anybody who uses Excel regularly, we\u2019ve put together our … Continue reading “These 5 Excel Tips and Tricks Will Save you Time”<\/span><\/a><\/p>\n","protected":false},"author":9073,"featured_media":91711,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":1},"categories":[2441],"tags":[],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-91706","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t