Use of Function keys in Excel

Excel Tip #028

Use of Function keys in Excel

Most of us know few function keys that are used as shortcuts in Excel, but hardly make use of it. Either because of the keyboard settings or due to the scarcity of the knowledge.

 Below, the use of function keys are tabulated along with their combinations which will make your life much more easier.
Function Key = F1 to F8

Function Key = F9 to F12
Try to use these Function key shortcuts in your day to day tasks and be benefited.

Comments

Post a Comment

Popular posts from this blog

VLOOKUP - Exact Match & Approximate Match

Image
Excel Tip #013 VLOOKUP - Exact Match & Approximate Match In the previous tip #012 (VLOOKUP & INDEX + MATCH), we learnt about VLOOKUP, it's syntax and how to use it. We also learnt about its drawback and how INDEX & MATCH can be helpful. Like said in the previous tip, there are 2 match option available in VLOOKUP - Exact & Approximate Match . Let us first refresh the syntax of VLOOKUP. Syntax: = VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) In simple terms, =  VLOOKUP (value/data that is used as reference, data table, the column # where our resultant data resides, exact (or) approximate match) Let's have a closer look at the last argument you supply to the Excel VLOOKUP function - range_lookup. You are likely to get different results in the same formula depending on whether you enter TRUE or FALSE (Approximate or Exact). If range_lookup is set to FALSE , the formula searches for exact match, i.e. for the lookup value exa...
Read more

Search Backwards in Excel

Excel Tip #022 Search Backwards in Excel Sometimes we take some things for granted in Excel and assume that everyone else knows too. Here's a tip which lot of Excel users don't know about it. Many Excel users know that the quickest way to find something in a large worksheet is to use Excel's Find command. On the Home tab, in the Editing group, click Find & Select , then Find or, preferrably, use the keyboard shortcut CTRL+F instead. Each time you click Find Next you will be taken to the next matching cell, starting from the active cell and going down the sheet until you finally come to the last one. But what if you want to find the 'last' matching value in a sheet and there are dozens or even hundreds of matching values? You don't want to click through each one until you finally reach the end. Here's a simple trick that will save you some time. Select a cell below the range you want to search ( CTRL+END is a shortcut you can use to quick...
Read more

Keyboard shortcuts for formatting

Excel Tip #020 Keyboard shortcuts for formatting A lot of us use keyboard shortcuts but when it comes to formatting a spreadsheet, these shortcuts go for a toss as formatting relies on mouse. But there are few simple & effective shortcuts which would help us a lot. Below are some... CTRL+1 – Format anything This shortcut is powerful. Select anything (cells, chart objects, drawing shapes, pictures etc.) and press CTRL+1 to instantly launch format dialog box. ALT EST (or ALT HVE) – Format painter If you want to copy the formatting from one thing to another (like formatting of a bunch of cells to another range, a chart to another chart), you can use Format painter. Simply copy the original object (CTRL+C), select the target object and press ALT+EST (one key after another). You may also use ALT+HVE (again one key after another) in all modern versions of Excel. ALT HH – Fill color Now comes the tricky one. If you want to fill some color in a chart object, drawing shape,...
Read more