Reject Invalid Dates in Excel This example shows how to use data validation to prevent entering invalid dates. 1. Select the range A2:A4. 2. Go to the Data tab, and in the Data Tools group, click Data Validation. 💎 Outside a Date Range Excel data validation for date entry: 3. Read more
Paste Special Shortcuts in Excel To open the Paste Special dialog box in Excel, press Ctrl + Alt + V on your keyboard. Now, press the letter that is underlined to paste formulas, values, or formatting. 💎 Paste Formulas To paste formulas only, execute the following steps. 1. Click on Read more
Show Formulas in Excel By default, Excel shows the results of formulas. To view the formulas in the worksheet instead of their calculated values, press CTRL + `. This key is located above the Tab key. 1. When a cell is selected in Excel, the corresponding formula is displayed in Read more
Convert Formula to Value in Excel If you want to turn a formula into a value, or convert many formulas to values in Excel, do the following steps. 1. Select a cell with a formula. 2. Press F2 to switch to editing mode. 3. By pressing F9, you can replace Read more
How to Delete Rows in Excel Shortcut Click on the row you want to delete, then press CTRL + – (minus sign) to remove it in Excel. To remove multiple rows quickly, highlight the rows and apply the same shortcut. 💎 Delete Row Please perform the following steps to delete Read more
Save As Shortcut in Excel To open the Save As dialog box in Excel, simply press the F12 key. Press CTRL + S to quickly save any changes made to your workbook. It is a good practice to save your Excel file regularly while working on it. 💎 Save As Read more
Insert Row Shortcut in Excel Simply select a row in Excel and press CTRL, SHIFT, and + (Plus) to insert a new row quickly. Select more than one row and use the same shortcut to insert multiple new rows instantly. 💎 Insert Row To insert a new row in Excel, Read more
OFFSET function in Excel The OFFSET function helps you point to a cell or range of cells in Excel that is offset by a chosen number of rows and columns from the original reference. 💎 Return a Cell Now, we start with the OFFSET function to find a cell in Read more
Transpose Data in Excel The Transpose feature under Paste Special in Excel allows you to switch data from rows to columns or from columns to rows. You can also use the TRANSPOSE function. 💎 Paste Special Transpose To transpose data, execute the following steps. 1. Select the range A1:C1. 2. Read more
Flash Fill in Excel Flash Fill in Excel is a great tool. Learn to utilize Flash Fill to efficiently extract, merge, and manipulate data automatically. 💎 Extract Numbers Extract the numbers in column A using Flash Fill in Excel. 1. In cell B1, input the number 4645 to specify the Read more