Trending September 2023 # How To Use Excel Hacks With Keyboard Shortcuts? # Suggested October 2023 # Top 9 Popular

You are reading the article How To Use Excel Hacks With Keyboard Shortcuts? updated in September 2023 on the website Khongconthamnam.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 How To Use Excel Hacks With Keyboard Shortcuts?

Excel Hacks (Table of Contents)

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Introduction to Excel Hacks How to Use Excel Hacks?

Here we discuss the list of most of Microsoft Excel’s significant shortcut buttons and main combinations with examples.

You can download this Excel Hacks Template here – Excel Hacks Template

Example #1 – Use of Important Keyboard Shortcuts

1. Selection of Data

2. Column Width Size Adjustment

3. Insertion of Date or Time or Comments in Excel

In some scenarios, we need to enter today’s date & time; instead of looking into the calendar or time at the bottom, we can use the below-mentioned shortcut key.

For date: CTRL + ; or For time: SHIFT + CTRL + ;

4. Addition of a New Line in a Cell

Suppose you are entering address details, and you need to add multiple lines of data in the same cell; for that, you need to enter short cut key “Alt + Enter”, it will move the cursor down so that you can enter or type the text in the next line.

5. Addition or insertion of multiple columns or rows

6. Autosum the Selected Data Range

Suppose I have a numeric data range, so I want to do a sum up for that data range. To perform this task faster, you need to select the data range.

After pressing the “ALT key and Enter”, it will give the range’s total value.

7 Addition of Cell Border

Here we want to add a cell border across the data range.

After pressing on “Ctrl + Shift + &”, cell borders are automatically added.

8. Number Formatting

You can select a date range if you want a dollar sign displayed before each number.

9. Make a Copy of your Worksheet in the Same Workbook

Suppose you have a quarterly report in sheet 1 of a workbook, so you need to re-create it from scratch for the next quarter’s sales data, which is very difficult and time-consuming; you can use the “Move or Copy” option under the worksheet.

10. Freeze the Top Row

11. Addition of Filter for a Data Range

Suppose you want to filter data in a worksheet.

Example #2 – Usage of Important Formulas

1. To Count Blank Cells in the Data Range with the help of the COUNTBLANK Formula

Here in the below-mentioned example, I want to count a blank cell in the data range (A2 to A7).

2. To Count Only Text Value in the Data Range with the help of COUNTA Formula

In the below-mentioned example, I want to count only a cell containing text values in the data range (A12 To A17); I can use the combination of the count formula, i.e., the COUNTA formula will count everything, including text & numeric value.

After using the COUNT formula, it will count only the numbers, i.e., = COUNTA (A2:A7)-COUNT (A2:A7). The difference between these two will result in an output value of 2.

3. To know the Formula Text or which formula you have used

If you know which formula is present in a cell, you can check it out with the help of the =FORMULATEXT(cell reference) formula. Here I have used cell A8 (as a cell reference).

After using the formula, the output is shown below.

4. To Pullout Only Decimal Values with the help of MOD & INT Function

I have a cell value of 98.23 in cell “A2” I want only the decimal portion in cell “B2”; to get this, I can use the formula MOD & INT function.

After using the formula, the output is shown below.

Things to Remember

With the help of the symbols or arithmetic operators explained in the above examples in user or predefined Excel formulas, you can quickly perform various required calculations between numbers, cells, entire rows, and columns or ranges of cells.