Macro VBA code to delete rows in excel sheet meeting multiple conditions 1. Add a button to a new sheet 2. Right click on button […]
Category: Excel Articles
Excel Data Validation
Use data validation in Excel to make sure that users enter correct values into a cell. Data validation option is found under Data Menu in […]
Which key displays the keyboard shortcuts on the Excel Screen?
Which key displays the keyboard shortcuts on the Excel Screen? Alt
Use Consolidate in Excel with an example
Use Consolidate in Excel with an example Consolidate option under Data menu is used to perform summary calculations on values in corresponding cells in various […]
Create Custom List in Excel
Step 1 : Navigate to Excel Options -> Click on Advanced Step 2 : Navigate to General Section -> Click to Edit Custom Lists Step 3 […]
Key Shortcut to navigate from one Sheet to Another Sheet in Excel
Key Shortcut to navigate from one Sheet to Another Sheet in Excel Use Ctrl + PgDn – Navigate to Sheet in rightUse Ctrl + PgUp – Navigate […]
Enable or Disable fill handle in Excel
Enable or Disable fill handle in Excel One can turn this option on or off by following below steps: Click the Microsoft Office Button , and then […]
How many rows of data can one excel sheet capture (versions after 2007)?
Question : How many rows of data can one excel sheet capture (versions after 2007)? Answer : 1048576
Excel: Lookup a text within string and return Yes or No if text exists
Excel: Lookup a text within string and return Yes or No if text exists IF(ISNUMBER(LOOKUP(2^15,SEARCH(“SearchString”,G2))),”Yes”,”No”)