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

How To Delete an Instagram Account Permanently

  Instagram is a photo and video-sharing social networking service that is owned by Facebook. Here, you how to delete your Instagram account permanently. Once your account is deleted your all photos, videos, followers, and all other account data will be gone forever. After Deleting your account you will not be able to use the same username again. 1) Go To https://help.instagram.com in web Browser.  2) Click on Managing Your Account.   3) Click on Delete Your Account.    4) Click next to "How do I delete my Instagram account?"  5) Click on "Delete Your Account" which is highlighted in blue. 6) Login into your Instagram account. Enter your username (or Email Address) and Password then Login. 7) Select your reason "Why are you deleting your account?" 8) Re-enter your Password to confirm permanently delete your account. 9) Click on Permanently delete my account. After clicking open pop-up window prompting to you confirmation. Click OK . Your account has bee...
1 comment
Read more

How To Convert Word File to PDF

Step 1: First open word file which you want to convert to pdf Step 2: Go To File -> Save As ->Give pdf file name ->Select File Type as PDF Step 3: After your file ready to pdf view Note: If PDF file type does not display then download doPDF. doPDF is a Portable Document Format printer developed by Softland, that allows any program that can print to create a PDF file. Download Link is Here https://www.dopdf.com/  Also, Read this : How to download any youtube video on your computer or laptop Switch Between more than one opened program Five Top windows 10 Tips you Don't Miss
2 comments
Read more