Skip to main content

ChatGPT Tips and Tricks for Daily Use

Post a Comment

10 Most Useful MS Excel Shortcut Keys

Excel Shortcut Key

We all use MS Excel for calculating any kind of Mathematical and financial statement.
In MS-Excel we can make Marksheet, Salary statement, and Chart, Pivot table.
Excel: Excel is used for data analysis and numeric manipulation.
Some formulas and some trick here provided to master in calculating.

1) Insert New Sheet

How to Insert New Sheet in Excel? Here, using this shortcut key you can insert a new Sheet.
"Shift+F11" key use to insert a "New Sheet" in your currently open excel workbook.

2) Insert Chart Sheet

How to Insert New Chart Sheet in Excel? Here, using this shortcut key you can insert a new chart  Sheet.
"F11" function key use to insert a "New Chart Sheet" in your currently open excel workbook.

3) Quick Navigation

  • Ctrl+End - navigate to the furthest right cell you’ve entered data in
  • Ctrl+Home - navigate to start.
  • Ctrl+right arrow - navigate to the furthest right of the excel sheet.
  • Ctrl+left arrow - navigate to the furthest left of the excel sheet.
  • Ctrl+up arrow - navigate to the top of the excel.
  • Ctrl+down arrow - navigate to the down of the excel.
  • Ctrl+F1 - Show/Hide the Excel Ribbon. 

4) Entering Data

  • F2 -  For Edit the Current Cell.
  • Alt+Enter - Enter a new line in cell Editing Mode.
  • Ctrl+D - Copy the content and format of the first cell to the selected cells below.
  • Ctrl+Y - Repeat the last Action.   

5) Formatting the data

  • Ctrl+1 - It Open the "Format Cells" Dialog Box.
  • Ctrl+T - It Convert selected cells to table. 

6) Working With Formula

  • Tab - Autocomplete the function name.
  • Ctrl+` -  Toggle between displaying cells value and Formulas.
  • Ctrl+' - Insert the formula of the above cells into the current selected cells or formula bar. 

7) Selecting Data

  • Ctrl+A - Select the entire worksheet.
  • Ctrl+Space - Select the entire column.
  • Shift+Space - Select the entire row.
  • Ctrl+Home OR Ctrl+Shift+End - Select the entire range of actual used data in current worksheet.

8) Indent in cell

  • Ctrl+Alt+Shift+Tab - Decrease the margin between the border and the text in the cell.
  • Ctrl+Alt+Tab - Increase the margin between the border and the text in the cell

9) Find and Select

  • Ctrl+F - Find the crucial pieces of data.
  • Ctrl+H - If you misspelled a word or you want to replace it use find and replace function.

10) Filtering Data

  •  Ctrl+Shift+L - Enable to filtering of selected cells.

Labels:

Comments

Post a Comment

Popular posts from this blog

What is Blockchain?

Blockchain: A Simplified Explanation Imagine a digital ledger where records are stored in blocks linked together to form a chain. This chain is distributed across multiple computers, making it incredibly difficult to hack or manipulate. That's essentially what a blockchain is. Key Characteristics of Blockchain: Decentralized: No single entity controls the blockchain. It's managed by a network of computers. Immutable: Once data is recorded, it cannot be altered or deleted. This ensures transparency and trust. Secure: Cryptography is used to protect the data and verify transactions. Transparent: Everyone on the network can see the data, but identity remains private. How Does it Work? Transaction: A transaction occurs (e.g., sending money, transferring ownership of an asset). Verification: The transaction is verified by multiple computers on the network. Block Creation: Verified transactions are grouped into a block. Addition to Chain: The new block is added to the exist...
Post a Comment
Read more

Follow these tricks and tips for the precise result in Google search

  Here are some special tricks you can use if you don't find the results you want on Google search. Users cannot take full advantage of Google's enormous potential, as it is not possible for everyone to search for the right stuff on the web. Here are some tips, tricks, and features that will help you do a responsive search properly. Follow these Tricks: 1) Quotes( " key phrase " ) Improve the search when you don't find the right result even after searching the result in depth. Quotes shows search results for the exact phrase. For Example: type "seo book" in search box with double quote and you retrieve exact result. Also search the same search without double quote you see the difference between result.   If the quotes are removed, the proximity of the search terms still matters to the search engine, but it will now show documents whose contents don’t exactly match the order of the search phrase. 2) Info( info: ) Find information about the specific page...
Post a Comment
Read more