Log in
x
or
x
x
Register
x

or

Excel Tips: Developer > Macro or VBA

File

File > Excel Options

How to activate cell for editing with single clicking in Excel?

How to automatically save and close an Excel file after a certain idle time?

How to autosave Excel file after data entering?

How to disable F1 help key in Excel?

How to disable or do not allow Save & Save As options in Excel?

How to disable or stop auto fill feature in Excel?

How to disable right click on sheet tab in Excel?

How to disable save prompt when close workbook?

How to disable the right click menu in specified worksheet or whole workbook in Excel?

How to disable workbook save but only allow save as in Excel?

How to find the version of Excel you are using now?

How to force users to save as a macro enabled workbook?

How to type in or edit cell without double clicking it in Excel?

File > Import / Export

How to export all macros from one workbook to another workbook?

How to export and save each worksheet as separate new workbook in Excel?

How to export charts to graphics in Excel?

How to export comments from Excel to Word?

How to export Excel data (selection or sheets) to Text files in Excel?

How to export multiple columns into individual text files in Excel?

How to export range of cells in Excel to csv file?

How to export single or all charts from Excel worksheets to PowerPoint?

How to import / copy data from closed workbook into current workbook?

How to import csv file into worksheet?

How to import data from another worksheet?

How to import multiple csv files into multiple worksheets?

How to import multiple file names into cells in Excel?

How to import multiple text files from a folder into one worksheet?

How to import multiple text files to multiple sheets?

How to import text files to Excel as separate sheets with original names in Excel?

How to quickly batch import multiple csv/text/xml files in Excel?

How to quickly create folders based on cell values in Excel?

How to save / export only filtered data from Excel to csv file?

How to save a selection as individual file in Excel?

How to save a worksheet as PDF file and email it as an attachment through Outlook?

How to save all worksheets as values only?

How to save each sheet as separate text file from a workbook?

How to save just one worksheet in a workbook in Excel?

How to save or export each sheet as CSV/PDF file in Excel?

How to save worksheet data as csv file with / without double quotes?

How to save, export multiple/all sheets to separate csv or text files in Excel?

File > Open, Save, or Close

How to close and reopen active workbook?

How to open a closed workbook in Excel?

How to open a specific page of PDF document from Excel hyperlink?

How to open a specific Word document through Excel?

How to open an excel file by using browse window?

How to quickly close all workbooks except active one?

How to quickly open all Excel files from a folder?

How to quickly save a workbook to multiple locations in Excel?

How to save all open files/workbooks at once in Excel?

How to save an Excel filename with timestamp?

How to save and close active workbook without prompt by a Command Button in Excel?

How to save and close workbook after inactivity for a certain amount of time?

How to save Excel file with cell value?

How to save file with date and time in Excel?

How to use Save As function to automatically overwriting existing file in Excel?

File > Page Setup

How to add background color to headers or footers in Excel sheet while printing?

How to apply different headers or footers on each page on an Excel spreadsheet?

How to conditional inserting page breaks in Excel?

How to find and replace in header or footer in Excel?

How to insert page break every x rows in Excel?

How to insert page breaks when value changes in Excel?

How to insert page number into cell / header / footer in Excel?

How to print pages with roman numeral page numbers?

How to print X rows per page in Excel?

How to put cell value in header/footer in Excel?

File > Print

How to auto increment cell value after each printing?

How to exclude a specific worksheet when printing workbook?

How to exclude certain cell or area from printing in Excel?

How to only print the last page of a worksheet in Excel?

How to print all conditional formatting rules in a worksheet?

How to print all options in a drop down list in Excel?

How to print all sheets except one specific sheet in Excel?

How to print certain pages or worksheet based on cell value in Excel?

How to print each row/cell on a separate page in Excel?

How to print embedded charts only in Excel?

How to print even/odd pages only in Excel?

How to print last page first in Excel?

How to print long column on one page in Excel?

How to print multiple copies with sequence page numbers?

How to print multiple selected rows on one page in Excel?

How to print multiple selections on one page in Excel?

How to print multiple workbooks in Excel?

How to print odd or even pages only in Excel?

How to print only rows /cells with data in Excel?

How to print pages in reverse order of a worksheet?

How to print rows repeatedly at the bottom of every printed page in Excel?

How to print selected columns together on one page in Excel?

How to print sheet name or a list of sheet names in Excel?

How to print specific sheet based on cell values in Excel?

How to print worksheet with validation circles in Excel?

How to print worksheet without blank rows in Excel?

How to quickly print first page of each sheet?

How to quickly print hidden worksheets in Excel?

How to repeat rows on top of every printout except the last page in Excel?

How to repeatedly print titles in multiple sheets?

How to set print area to last row in Excel?

How to set print area to multiple worksheets at once time in Excel?

How to stop blank rows when printing worksheet?

File > View

How to apply freeze / unfreeze panes to multiple worksheets at once?

How to automatically expand formula bar in Excel?

How to blink or flash text of specified cell in Excel?

How to change sheet tab color based on cell value?

How to disable the research task pane in Excel?

How to display / show worksheet tabs vertically on left side of Excel?

How to display or hide sheet tabs and Sheet Tab Bar in Excel?

How to display or hide Status bar in Microsoft Excel?

How to display the active cell in top left in Excel screen?

How to hide row and column headings from all worksheets?

How to show or hide Horizontal & Vertical scroll bar in Microsoft Excel?

How to zoom all tabs in one size in Excel?

How to zoom or magnify selected cells in Excel?

How to zoom up or down the cells while clicking at data validation list in Excel?

File > Others

How to batch convert multiple CSV files to XLS(X) files in Excel?

How to batch convert multiple Excel files to CSV files in Excel?

How to check the size of each worksheet of workbook?

How to create monthly/yearly calendar in Excel?

How to open containing folder of current workbook in Microsoft Excel?

How to open specific Outlook folder from Excel?

Insert

Insert > Illustrations

How to add mouse over tip to a certain shape in Excel?

How to auto change shape size based/dependent on specified cell value in Excel?

How to autocomplete a textbox when typing in Excel?

How to automatically change all pictures to move and size with cells in Excel?

How to automatically resize the text box to fit the content in Excel?

How to center a picture in an Excel cell?

How to change shape color based on cell value in Excel?

How to change textbox color based on value in Excel?

How to check if textboxes in userform are empty or not in Excel?

How to clear contents of textbox when clicked in Excel?

How to convert image URLs to actual images in Excel?

How to create qr code based on cell value in Excel?

How to disable editing in textbox to prevent user inputting in Excel?

How to display images from a range of file paths in Excel?

How to enlarge image when click on it in Excel?

How to enlarge or shrink picture with one click in Excel?

How to format a textbox as a percentage in Excel?

How to format a textbox as currency in Excel?

How to hide or unhide a certain shape based on specified cell value in Excel?

How to insert floating table or textbox in Excel worksheet?

How to insert multiple pictures and resize them at once in Excel?

How to insert picture into text box?

How to insert the same image into multiple worksheets quickly?

How to make a shape blinking or flashing over and over in Excel?

How to remove border from text box in Excel?

How to resize pictures to fit cells in Excel?

How to rotate an image based on a cell value in Excel?

How to set a default value in a textbox?

How to set tab order to textboxes in Excel?

Insert > Links

How to automatically link a cell color to another in Excel?

How to batch remove hyperlinks at once in Excel?

How to break all external links in Excel?

How to change multiple hyperlink paths at once in Excel?

How to convert a bunch of text URLs to active hyperlinks in Excel?

How to convert external links to values in Excel?

How to convert hyperlink to plain text in Excel?

How to convert multiple email addresses to hyperlinks in Excel?

How to convert url text to clickable hyperlink in Excel?

How to create a hyperlink to a chart in Excel?

How to create hyperlinked index of sheets in workbook?

How to display hyperlink results at top of page in Excel?

How to extract actual addresses from hyperlinks in Excel?

How to follow hyperlink to hidden sheet in Excel?

How to hide hyperlink addresses in Excel?

How to hyperlink a command button to a URL address in Excel?

How to link checkboxes to multiple cells in Excel?

How to link or reference checkbox name to a cell in Excel?

How to link Pivot Table filter to a certain cell in Excel?

How to link textbox to multiple cells in Excel?

How to open hyperlinks without a mouse in Excel?

How to open multiple hyperlinks at once in Excel?

How to remove hyperlinks without removing formatting?

Insert > List

How to create a dynamic list of worksheet names in Excel?

How to create a list from same cells across multiple sheets in Excel?

How to create a list of unique values from multiple worksheets in Excel?

How to create a table of contents for all spreadsheets tab name with hyperlinks in Excel?

How to create and list all worksheet names from a workbook?

How to generate lottery numbers in excel?

How to generate or list all possible permutations in Excel?

How to get list of sheets names in Google sheets?

How to list all dates between two dates in Excel?

How to list all file names from a folder and sub-folders into a worksheet?

How to list all filenames in a folder and create hyperlinks for them in Excel?

How to list all files in folder and subfolders into a worksheet?

How to list all folders and subfolders in Excel?

How to list all formulas in Excel?

How to list all open workbooks and easily shift between workbooks in Excel?

How to list all opening (currently running) applications in Excel?

How to list all pivot tables from a workbook?

How to list all table names in Excel?

How to list all visible or hidden sheets from workbook?

How to quickly create simple to do list in Excel?

How to quickly create unique list (remove duplicates) from a given column in Excel?

How to quickly list all hyperlinks in Excel?

How to quickly list the picture names/file names of a folder to Excel cells?

Insert > PivotTable & PivotChart

How to add multiple fields into pivot table?

How to automatically refresh a Pivot Table in Excel?

How to change multiple field settings in pivot table?

How to create clickable hyperlinks in pivot table?

How to disable select multiple items in pivot table?

How to filter Pivot table based on a specific cell value in Excel?

How to hide subtotals in pivot table?

How to hide/show pivot table field list in Excel?

How to keep slicer of Pivot Table moving with worksheet scrolling in Excel?

How to refresh pivot table on protected sheet?

How to refresh pivot table when data changes in Excel?

Insert > Rows & Columns

How to auto insert row based on cell value in Excel?

How to copy and insert row multiple times or duplicate the row x times in Excel?

How to disable ability to insert row and column in Excel?

How to insert a blank new row automatically by Command Button in Excel?

How to insert blank row above specific text in Excel?

How to insert blank row based on above cell value in Excel?

How to insert blank rows when value changes in Excel?

How to insert numbers or rows for missing sequential numbers in Excel?

How to insert or delete partial row in Excel?

How to insert specific number of rows at fixed intervals in Excel?

How to quickly insert blank /empty rows in Excel?

How to quickly insert blank column between every other column in Excel?

How to quickly insert space between each row in Excel?

How to repeat rows a specified number of times based on another column in Excel?

Insert > Others

How to add check mark in a cell with double clicking in Excel?

How to add new sheet with specific name in Excel?

How to add new worksheet with current date in Excel?

How to auto number merged cells in Excel?

How to auto number or renumber after filter in Excel?

How to create a calendar in Excel?

How to create a pie chart for YES/NO answers in Excel?

How to create a sheet if not exist in the workbook?

How to create multiple worksheets from a list of cell values?

How to create new sheets for each row in Excel?

How to create new workbook with specific number of worksheets?

How to create sheet names from a list in Excel?

How to create stopwatch in Excel worksheet?

How to delete all charts in Excel Workbooks?

How to find and replace text in chart titles in Excel?

How to hide or show chart axis in Excel?

How to number rows after inserting or deleting rows automatically in Excel?

How to numbering the cells with alphabetical letters in Excel?

How to quickly create multiple sheets with same format in Excel?

How to quickly insert tick and cross marks into cells?

How to resize all charts or pictures in Excel quickly?

How to set absolute position of a chart in Excel?

Edit

Edit > Change cell content

How to add / insert certain character every x characters into cells?

How to add prefix or suffix to range of cells in Excel?

How to add strings of text to multiple cells in Excel?

How to add text in middle of selected cells in Excel?

How to add text to the beginning or end of all cells in Excel?

How to capitalize all letters in cell or a column in Excel?

How to capitalize first letter only or first letter of each word in Excel?

How to change cell value by clicking on the cell?

How to change text strings to sentence case in Microsoft Excel?

How to change uppercase to lowercase in Microsoft Excel?

How to change uppercase to proper or title case in Microsoft Excel?

How to change value based on cell color in Excel?

How to convert all caps to only first cap in selected range in Excel?

How to convert text string to proper case with exceptions in Excel?

How to flip the first and last name in cells in Excel?

How to force text string to uppercase / lowercase / proper case in Excel?

How to force uppercase of text entry in a textbox?

How to insert / add apostrophe in front of numbers in Excel?

How to insert / add space after every x characters in cells?

How to insert brackets around text in a cell?

How to insert colon between numbers to make them as time format automatically in Excel?

How to insert spaces before capital letters in excel?

How to quickly convert/change text to upper cases in Microsoft Excel?

How to rearrange text in a cell in Excel?

How to reverse domain name by notation in Excel?

How to reverse text string or words order in Excel?

How to swap or switch text around within one cell in Excel?

Edit > Combine

How to collect data from multiple sheets to a master sheet in Excel?

How to combine contents of multiple cells without losing data in Excel?

How to combine multiple columns into one list in Excel?

How to combine multiple rows into one based on duplicates in Excel?

How to combine multiple workbooks into one master workbook in Excel?

How to combine rows with same ID/name in Excel?

How to combine two lists without duplicates in Excel?

How to concatenate cell columns and keep text color in Excel?

How to concatenate cell values until if finds a blank cell in a column?

How to concatenate cells if same value exists in another column in Excel?

How to concatenate rows into one cell based on group in Excel?

How to concatenate texts of multiple cells into a textbox in Excel?

How to convert column list to comma separated list in Excel?

How to merge multiple sheets with same headers in Excel?

How to merge or consolidate worksheets or workbooks into one worksheet?

How to quickly merge adjacent rows with same data in Excel?

How to quickly merge rows based on one column value then do some calculations in Excel?

Edit > Convert

How to change negative numbers to positive in Excel?

How to change positive numbers to negative in Excel?

How to convert all tables to ranges in active Worksheet?

How to convert decimal degrees to degrees minutes seconds in Excel?

How to convert html to text in cells in Excel?

How to convert month name to number in Excel?

How to convert text in text box to cell content in Excel?

How to convert yyyymmdd to normal date format in Excel?

How to quickly convert / change numbers to words in Excel?

How to quickly convert an array table to a list table in Excel?

How to reverse signs of values in cells in Excel?

Edit > Copy & Paste

How to auto copy and paste cell in current sheet or from one sheet to another in Excel?

How to automatically copy a cell to clipboard with single click in Excel?

How to convert crosstab table (2-dimensional table) to list in Excel?

How to convert matrix style table to three columns in Excel?

How to copy a hidden sheet in Excel?

How to copy a selected range to a new workbook in Excel?

How to copy and paste only non-blank cells in Excel?

How to copy cell without new line break in Excel?

How to copy Combo Box value to active cell in Excel?

How to copy current cell address to other location in Excel?

How to copy data from protected sheet?

How to copy data to another worksheet with Advanced Filter in Excel?

How to copy data to next empty row of another worksheet in Excel?

How to copy hyperlink only from one cell to another in Excel?

How to copy image from worksheet to userform in Excel?

How to copy multiple selections or ranges in Excel?

How to copy multiple sheets multiple times in Excel?

How to copy one chart format to others in Excel?

How to copy one filled color only to a range in Excel?

How to copy only borders of selected range in Excel?

How to copy rows and paste to another sheet based on date in Excel?

How to copy sheet and rename automatically in Excel?

How to copy sheet and rename based on cell value in Excel?

How to copy sum of selected cells only in Excel?

How to copy values and formatting from a range to another in Excel?

How to copy worksheet to end of workbook in Excel?

How to create list from range in Excel?

How to disable cut, copy and paste functions in Excel?

How to duplicate rows based on cell value in a column?

How to easily and quickly transpose range and stack data in Excel?

How to merge two columns into one with alternating values in Excel?

How to move every other row to column in Excel

How to only copy formatting from a range to another in Excel?

How to paste a range of cells into message body as image in Excel?

How to paste all except formulas in Excel?

How to paste external content to Excel always match destination formatting?

How to paste values to visible/filtered cells only in Excel?

How to quickly stack multiple columns into one column in Excel?

How to quickly swap contents of two cells in Excel?

How to quickly transpose address list from rows to columns in Excel?

How to reference format and value from another cell in Excel?

How to repeat cell value x times in Excel?

How to restrict to paste values only (prevent formatting) in Excel?

How to set paste values as default paste when using Ctrl + V in Excel?

How to stack columns from left to right into one column in Excel?

How to swap rows or columns in Excel?

How to transpose / convert columns and rows into single column?

How to transpose / convert columns and rows into single row?

How to transpose cells in one column based on unique values in another column?

How to transpose columns to rows and insert new rows to fill down data in Excel?

How to transpose duplicate rows to columns in Excel?

How to transpose every 5 or n rows from one column to multiple columns?

How to transpose/convert a single column to multiple columns in Excel?

Edit > Delete & Clear

How to batch remove hyperlinks at once in Excel?

How to clear contents and formatting at the same time in cells in Excel?

How to clear contents of named range in Excel?

How to clear entire sheet or specified range in Excel?

How to clear specified cell contents if value of another cell changes in Excel?

How to clear specified cell contents on open and exit in Excel workbook?

How to clear the contents of multiple merged cells in Excel?

How to delete active workbook (current file) in Excel?

How to delete all blank lines or only the first line in cell in Excel?

How to delete all but selected ranges in Excel?

How to delete all hidden rows or columns in Excel?

How to delete all pictures or other objects in Excel easily?

How to delete all rows below certain row or active cell in Excel?

How to delete all rows containing specific text within a column in Google sheets?

How to delete all rows except the first header row in Excel?

How to delete all sheets except specified/current one in Excel?

How to delete all the blank worksheets in Excel?

How to delete empty columns with header in Excel?

How to delete entire columns based on header value in Excel?

How to delete entire row if cell contains zero in Excel?

How to delete hidden worksheets in Excel?

How to delete multiple empty columns quickly in Excel?

How to delete one or all pivot tables in Excel?

How to delete rows above active cell or specific text in Excel?

How to delete rows based on background color in Excel?

How to delete rows if cell is greater/less than a certain value in Excel?

How to delete rows if cells are blank in a long list in Excel?

How to delete rows not containing certain text in Excel?

How to delete rows not matching criteria on another sheet?

How to delete rows with missing/blank values in certain columns in Excel?

How to delete rows with negative values in Excel?

How to delete same rows or ranges across multiple sheets in Excel?

How to delete sheet if name contains specific text from workbook?

How to delete sheet if sheet name not in a list?

How to delete specific sheet if exists in workbook?

How to delete unique values from a column in Excel?

How to delete worksheet based on cell value in Excel?

How to delete worksheet without prompt or warning in Excel?

How to filter a list and delete the rest hidden or visible rows in Excel?

How to keep or delete leading zeros in Excel?

How to only delete visible rows or columns in Excel?

How to prevent deleting rows or columns in a shared unprotected workbook?

How to quickly delete all autoshapes in Excel?

How to quickly delete all contents of unlocked / unprotected cells in Excel?

How to quickly delete all html objects in Excel?

How to quickly delete all text boxes in Excel?

How to quickly delete every other row in Excel?

How to quickly remove conditional formatting in Excel?

How to quickly remove dashes from cells in Excel?

How to quickly remove line breaks in Excel?

How to remove / delete all or multiple hyperlinks in Excel?

How to remove all buttons or Command buttons in Excel?

How to remove all duplicates but keep only one in Excel?

How to remove all HTML tags from string in Excel?

How to remove alpha characters from cells in Excel?

How to remove blank or empty rows in Excel?

How to remove cells or rows if not bold in Excel?

How to remove conditional formatting but keep format in Excel?

How to remove duplicate rows and keep highest values only in Excel?

How to remove duplicate rows but keep the one with latest date in Excel?

How to Remove Duplicate Rows in Excel ?

How to remove duplicates but keep first instance in Excel?

How to remove duplicates but keep rest of the row values in Excel?

How to remove empty sheets from a workbooks

How to remove extra spaces between words in cells in Excel?

How to remove leading apostrophe from numbers in Excel?

How to remove leading spaces in cells in Excel?

How to remove non numeric characters from cells in Excel?

How to remove non-alpha characters from cells in Excel?

How to remove non-alphanumeric characters in Excel?

How to remove non-English characters in Excel column?

How to remove numeric characters from cells in Excel?

How to remove or delete all strikethrough texts or characters from cells in Excel?

How to remove personal information of a workbook?

How to remove rows based on cell value in Excel?

How to remove trailing spaces from cells in Microsoft Excel?

How to remove/delete all spaces after the last character in Excel?

Edit > Extract

How to dynamically extract a list of unique values from a column range in Excel?

How to extract actual addresses from hyperlinks in Excel?

How to extract data from chart or graph in Excel?

How to extract decimal value from string in Excel?

How to extract hyperlinks from multiple images in Excel?

How to extract images from comments in Excel?

How to extract last number from text string in Excel?

How to extract number only from text string in Excel?

How to extract numbers from mixed alphanumeric text strings in Excel?

How to extract postcode from address list in Excel?

How to extract text between single or double quotes from cells in Excel?

How to extract unique values from multiple columns in Excel?

How to quickly extract email address from text string?

How to quickly extract filename from full path in Excel?

Edit > Fill cell content

How to auto add/enter current date/time in a cell with double clicking in Excel?

How to auto populate date in cell when adjacent cell is updated in Excel?

How to autofill formula when inserting rows in Excel?

How to automatically enter date when data entered in a column?

How to automatically generate invoice number in Excel?

How to fill blank cells with 0 or other specific value in Excel?

How to fill blank cells with dash in Excel?

How to fill down sequence numbers skip hidden rows in Excel?

How to find and replace all blank cells with certain number or text in Excel?

How to get the active workbook location/path in Excel?

How to get the current sheet number of a workbook?

How to insert current timestamp when data in another cell changes in Excel?

How to insert date stamp into a cell if ticked a checkbox in Excel?

How to insert last modified date in Excel header or footer?

How to insert same text in every other row in Excel?

How to insert timestamp automatically when data is updated in another column in Google sheet?

How to insert timestamp into specific cell when macro is run in Excel?

How to insert timestamp with seconds in Excel?

How to make a particular cell mandatory enter before closing workbook?

How to quickly insert sheet names in cells in Excel?

How to quickly insert windows username in cell in Excel?

How to record date and time automatically when cell changes?

How to reference same cell from multiple worksheets in Excel?

How to repeat a cell value until new value is seen or reached in Excel?

Edit > Find

How to always search in whole workbook?

How to find all possible sums of two numbers in a list in Excel?

How to find all underlined texts in a range or whole worksheet in Excel?

How to find and get the value of first visible cell after filtering in Excel?

How to find and list all links (external references) in Excel?

How to find duplicate or unique values in two columns of two sheets?

How to find duplicate values in two columns in Excel?

How to find first blank cells in column in Excel?

How to find the last row or column with data in Excel?

How to loop through files in a directory and copy data into a master sheet in Excel?

How to loop through rows until a specific value found in Excel?

How to loop through rows until blank in Excel column?

How to quickly search a value in multiple sheets or workbooks?

How to search by worksheet name in Excel?

Edit > Go to

How to always at cell A1 when opening workbook?

How to automatically move cursor to specific cell in Excel?

How to click on alphabet letter to go to cell which starts with that letter in Excel?

How to double click a cell to open a specified worksheet in Excel?

How to go back to previous/last sheet with shortcut in Excel?

How to go to a specific sheet in Excel?

How to go to first or last empty row in Excel?

How to jump to first / last /specific worksheet quickly in Excel?

How to move down to or select the next empty cell in a column in Excel?

How to move to next cell after input automatically in Excel?

How to move to the beginning or start of next row for data entry in Excel?

How to open a specific worksheet by the selected value of a Combo Box in Excel?

How to open specific worksheet in a workbook?

How to quickly jump between two tabs in Excel?

How to quickly jump to the adjacent cell based on the selection in an Excel dropdown list?

How to quickly jump to the cell with current date in Excel?

How to quickly tab between text boxes in Excel?

How to return to last active sheet in Excel?

How to toggle / switch between two sheets back and forth in Excel?

Edit > Hide & Unhide

How to auto hide rows if blank cells in a column?

How to automatically hide columns based on date in Excel?

How to automatically hide specific worksheets when opening an Excel file?

How to hide all worksheets except/but the specified or active one in Excel?

How to hide columns on multiple sheets in a workbook?

How to hide every other row in Excel?

How to hide formula but display the result without protecting worksheet in Excel?

How to hide multiple blank rows or columns in Excel at once in Excel?

How to hide or unhide a specific worksheet based on cell value in another sheet?

How to hide or unhide columns based on drop down list selection in Excel?

How to hide or unhide specified rows or columns when double-clicking a cell in Excel?

How to hide rows based on cell color in Excel?

How to hide rows based on cell value in Excel?

How to hide rows based on today’s date in Excel?

How to hide rows with zero value in Excel?

How to limit scroll area of a worksheet in Excel?

How to lock screen to prevent scrolling in Excel worksheet?

How to only show print area in a worksheet in Excel?

How to quickly Hide Excel Workbooks in Excel?

How to quickly show active or selected sheets only in Excel?

How to set scroll position or hide other cells in Excel?

How to show only the last 4 digits of social security number (ssn) in Excel?

How to show or hide all objects (pictures/charts/shapes/comments) in Excel?

How to toggle between hidden and visible columns in Excel?

How to toggle between hidden and visible sheets in Excel?

How to unhide all worksheets & sheets in Excel?

Edit > Move

How to move a certain row into a new sheet when check box is checked in Excel?

How to move active sheet to end or front of current workbook in Excel?

How to move duplicate rows to another sheet in Excel?

How to move entire row to another sheet based on cell value in Excel?

How to move entire row to the bottom of active sheet based on cell value in Excel?

How to move last word to next adjacent cell?

How to move minus sign from right to left/back to front in Excel?

How to move specific files from one folder to another in Excel?

How to quickly move items between two list boxes in Excel?

Edit > Replace

How to change #DIV/0! error to the readable message in excel?

How to convert zero to blank in selected range in Excel?

How to find and replace multiple values at once in Excel?

How to find and replace numbers with subscript in Excel?

How to find and replace sheet tab names in Excel?

How to find and replace specific text in text boxes?

How to find and replace text then preserve formatting in Excel?

How to find and replace values greater than / less than a specific value in Excel?

How to quickly find and replace character with superscript in Excel?

How to replace all numbers in cells with X’s in Excel?

How to replace alt-enter with space/comma in Excel?

How to replace commas with newlines (Alt + Enter) in cells in Excel?

How to replace multiple spaces with single space from cells in Excel?

How to replace non empty cells with specific value in Excel?

How to replace range names with cell references in Excel?

How to replace text with corresponding pictures in Excel?

Edit > Select

How to auto select text of a textbox when it is selected in Excel?

How to easily reverse selections of selected ranges in Excel?

How to identify and select all bold cells or text in Excel?

How to identify and select all merged cells in Excel?

How to quickly deselect cells from selected ranges in Excel?

How to quickly select named range cells in Excel?

How to select a column based on the column header in Excel?

How to select all cells with data in Excel?

How to select all checkboxes using a single checkbox in Excel?

How to select all formula cells in a worksheet?

How to select all objects (pictures and charts) easily in Excel?

How to select all sheets except one in Excel?

How to select all unloked cells in Excel?

How to select and highlight diagonal cells in Excel?

How to select entire column except header/first row in Excel?

How to select every nth column in Excel?

How to select every other or nth row in Excel?

How to select last cell with data in a row/column in Excel?

How to select multiple items from drop down list into a cell in Excel?

How to select non-blank cells in a range in Excel?

How to select range based on cell value in another column in Excel?

How to select specific worksheet based on cell value on another sheet in Excel?

How to select used cells and range in Excel quickly?

How to synchronize all worksheets of the workbook with same range selected in Excel?

Edit > Split

How to convert comma separated text string to list or rows in Excel?

How to convert one cell to multiple cells/rows in Excel?

How to quickly split text string by case in Excel?

How to split a column every other row in Excel?

How to split a long column into multiple columns in Excel?

How to split a long list into equal groups in Excel?

How to split a workbook to separate Excel files in Excel?

How to split cell values vertically in Excel?

How to split cells into multiple columns or rows by carriage return?

How to split comma separated values into rows or columns in Excel?

How to split data into multiple worksheets based on column in Excel?

How to split data into multiple worksheets by rows count in Excel?

How to split word or number into separate cells in Excel?

Edit > Others

How to make sheet tab name equal to cell value in Excel?

How to name sheets based on cell values (from list) in Excel?

How to rename all images names in a folder according to a list of cells in Excel?

How to rename multiple files of a folder in Excel?

How to rename multiple worksheets in Excel?

How to rename worksheets based on cell values in Excel?

How to undo all changes to get back the original data in Excel?

Format

Format > Conditional Formatting

How to auto-highlight row and column of active cell in Excel?

How to highlight active cell or selection in Excel?

How to highlight all cells with comments in Excel?

How to highlight all misspelled words in worksheet in Excel?

How to highlight all named ranges in Excel?

How to highlight all subtotal rows at once in Excel?

How to highlight cell or row with checkbox in Excel?

How to highlight column or column header if it is filtered in Excel?

How to highlight duplicate values in different colors in Excel?

How to highlight entire / whole row while scrolling in Excel worksheet?

How to highlight specific text within a cell based on other text?

How to highlight the cells linked by hyperlinks in Excel?

How to highlight the modified/updated cells in Excel?

How to quickly change font size based on cell value in Excel?

How to quickly crosshair highlight active cell in Excel?

How to quickly shade alternating filtered rows in Excel?

Format > Format Cells

How to add border line below when value changes in an Excel column?

How to align duplicates or matching values in two columns in Excel?

How to apply color gradient across multiple cells?

How to auto-center checkbox in cell in Excel?

How to bold all specific words in a range of cells?

How to bold only the first line or first word in cell in Excel?

How to bold part text when concatenate two columns in Excel?

How to change border color of active cell in Excel?

How to change cell color when cell is clicked or selected in Excel?

How to color or highlight certain word in cells in Excel?

How to convert date from dot to slash format in Excel?

How to format mac addresses in cells by adding colon symbol in Excel?

How to increase or decrease the font size with shortcut key in Excel?

How to keep cell formatting while referencing other sheet cells?

How to make cell flash red in Excel?

How to make cells bold if greater than certain number in Excel?

How to preserve grid lines while filling color in Excel?

How to randomly add background/fill color for cells in Excel?

How to set cell color equal to another cell color in Excel?

How to shrink text to fit a cell in Excel?

How to unmerge cells and fill with duplicate values in Excel?

Format > Others

How to auto fit column width in Excel?

How to auto fit row height of merged cells in Excel?

How to change the row height / column width alternated in Excel?

How to change the row height based on cell value in Excel?

How to display date format in combo box output in Excel?

How to protect cell formatting but only allow data entry in Excel?

How to quickly restore to default cell size in Excel?

How to remove tab color in Excel?

How to resize multiple cells to fit pictures quickly in Excel?

How to set cell size in cm (centimeters) in Excel?

How to specify date or datetime format in header or footer?

How to square multiple cells in Excel?

Data

Data > Check

How to check if / find cells contains formulas in Excel?

How to check if a cell contains picture in Excel?

How to check if a certain range name exists in Excel?

How to check if a workbook is saved?

How to check if hyperlink exists in a worksheet in Excel?

How to check if row is hidden in Excel?

How to check or determine data type of cell?

How to find or check if a specific workbook is open or not in Excel?

How to quickly check if a file (workbook) is open or closed in Excel?

How to quickly check if a sheet is empty in Excel?

Data > Data validation

How to add tick and cross symbols into drop down list in Excel?

How to allow only date format in specific cells?

How to allow only numbers to be input in text box?

How to auto display a default value while deleting value in drop-down list in Excel?

How to autocomplete when typing in Excel drop down list?

How to circle around a cell in Excel?

How to create a drop down list with hyperlinks to every sheet in Excel?

How to create a drop down list with multiple checkboxes in Excel?

How to create a searchable drop down list in Excel?

How to create drop down list but show different values in Excel?

How to create drop down list with hyperlinks in Excel?

How to create drop down list with multiple selections or values in Excel?

How to increase drop down list font size in Excel?

How to only allow negative numbers in Excel?

How to only allow unique values in Excel?

How to prevent blank or missing entries in cells in Excel?

How to prevent saving if specific cell is blank in Excel?

How to prevent special characters entering in Excel?

How to set a default value in data validation drop-down list in Excel?

How to show the first item in the drop down list instead of blank?

How to validate cells to only accept IP address in Excel?

Data > Filter

How to apply same filter to multiple sheets In Excel?

How to autofilter rows based on cell value in Excel?

How to automatically reapply auto-filter when data changes in Excel?

How to clear filter cache (old items) from Pivot Table in Excel?

How to clear filters from all worksheets in active workbook in Excel?

How to clear filters when opening, saving or closing workbook in Excel?

How to display / show auto filter criteria in Excel?

How to do instant filtered search as you type in a cell in Excel?

How to filter all date cells before or after today in Excel?

How to filter cells by bold characters in Excel?

How to filter data from drop down list selection in Excel?

How to filter data just by clicking cell content in Excel?

How to filter data with hyperlinks in Excel?

How to filter dates between two specific dates in Excel?

How to filter values by first letter or last character in Excel?

How to update advanced filter result automatically in Excel?

Data > Sort

How to auto sort column by value in Excel?

How to auto sort date when date is entered or changed in Excel?

How to flip / reverse a column of data order vertically in Excel?

How to flip / reverse a row of data order in Excel quickly?

How to quickly sort IP address from low to high in Excel?

How to quickly transpose cells left to right in Excel?

How to reverse the order of worksheet tabs?

How to sort column data by clicking on header in Excel?

How to sort data on multiple worksheets at once?

How to sort multiple rows or columns independently at once in Excel?

How to sort numbers within a cell in Excel?

How to sort rows to put the blank cells on top in Excel?

How to sort sheets by a cell value in Excel?

How to sort worksheet tabs by color in Excel?

How to sort worksheets in alphabetical / alphanumeric order in Excel?

Data > Others

How to compare alphanumeric values in two columns in Excel?

How to compare two columns and highlight the unmatched data in Excel?

How to compare two strings for similarity or highlight differences in Excel?

How to expand or close all group rows and columns in Excel?

How to group and ungroup rows in protected worksheet?

Review & Security

Review & Security > Comments

How to add comment to chart in Excel?

How to auto add date and time to comment in Excel?

How to auto-size comment box to fit its content in Excel?

How to change all comment formats in cells in Excel?

How to change all comments’ author name in Excel?

How to change comment indicator color in Excel?

How to convert cell contents to comments in Excel?

How to convert comments to cell contents in Excel?

How to delete all comments in a worksheet/workbook?

How to find and replace text within comments in Excel?

How to insert comments in protected worksheet?

How to insert formula result in Excel comment?

How to list all comments to a new worksheet or workbook in Excel?

How to only copy comments from cells to another in Excel?

How to quickly insert a comment to multiple cells in Excel?

How to reset all comment positions in Excel?

How to show comments when cell is selected in Excel?

Review & Security > Protect cells

How to encrypt/decrypt selected cells in Excel?

How to lock and preotect nonempty cells in Excel?

How to lock and unlock specified cells with a checkbox in Excel?

How to lock or protect cells after data entry or input in Excel?

How to lock or unlock cells based on values in another cell in Excel?

How to lock specified cells without protecting the whole worksheet in Excel?

How to make cell as read only in Excel?

How to prevent specific cell contents from being deleted in Excel?

How to protect cells based on date in Excel?

How to protect or lock cell values based on background color?

Review & Security > Protect Sheets

How to allow edit objects in protected worksheet in Excel?

How to allow external data refresh in protected worksheet in Excel?

How to allow spell check in a protected worksheet in Excel?

How to auto protect a specific worksheet in Excel?

How to automatically protect all worksheets when closing the Excel workbook?

How to check if worksheet or workbook is protected in Excel?

How to lock a sheet position for always visible in Excel Workbook?

How to prevent a certain worksheet from being deleted in Excel?

How to prevent from changing sheet name in Excel?

How to prevent selection of multiple worksheets in Excel?

How to prevent users from printing worksheet?

How to recover lost worksheet protection password in Excel?

How to set password to protect hidden sheet in Excel?

How to toggle (turn on/off) worksheet protection in Excel?

How to unprotect multiple worksheets at once in Excel?

Review & Security > Others

How to apply spell check in textbox?

How to lock or freeze worksheet tab in Excel?

How to prevent or disable edit mode by double clicking cell in Excel?

How to prevent others from inserting worksheet in Excel?

How to protect all workbooks in a folder at once in Excel?

How to protect conditional formatting rules in Excel?

How to protect header and footer in Excel?

How to protect pivot table in Excel?

How to record changing values in a cell in Excel?

How to remember or save previous cell value of a changed cell in Excel?

How to track changes without sharing workbook?

Calculation & Formulas

Calculation & Formulas > Calculation options

How to hide inconsistent formula error in Excel?

How to highlight all cells referenced by a formula in Excel?

How to only recalculate or refresh selected cells in Excel?

How to stop auto calculation in Excel?

How to trace precedents or dependents for a range of / multiple cells in Excel?

Calculation & Formulas > Math Functions

How to keep running total in one or a single cell in Excel?

How to quickly sum values excluding hidden columns in Excel?

How to round a range of cells in Excel?

How to round range of numbers to even in Excel?

How to sum cell values in a column until blank cell reached?

How to sum range of cells ignoring errors in Excel?

How to sum up values from textboxes?

Calculation & Formulas > Statistical Functions

How to count blank cells or nonblank cells in a range in Excel?

How to count cells with specific text and fill/font color in Excel?

How to count files in a certain folder/directory in Excel?

How to count number of cells with comments in Excel?

How to count number of peaks in a column of data in Excel?

How to count number of times a cell is changed in Excel?

How to count or sum cells based on cell color in Google sheet?

How to count the line breaks in cell in Excel?

How to count the number of printed pages in a sheet?

How to count the number of sheets of a workbook?

How to count the number of visible sheets in a workbook?

How to count the number of words in a cell or a range cells in Excel?

How to count the page numbers of Pdf files in Excel?

How to count total clicks in a specified cell in Excel?

How to count total rows in a table in Excel?

How to count worksheets with specific name in Excel?

How to count/sum cells by colors with conditional formatting in Excel?

How to quickly count the number of all opened workbooks?

How to quickly count the number of hidden worksheets in Excel?

Calculation & Formulas > Others

How to add values to multiple cells in Excel?

How to batch rename multiple range names in Excel?

How to change/convert absolute reference to relative reference in Excel?

How to create dynamic named range in Excel?

How to divide a range of cells by a number in Excel?

How to double click a cell and add 1 to that cell value in Excel?

How to find most common value (number or text string) from a list in Excel?

How to find or get the cell reference of the previous active cell in Excel?

How to find where a certain named range is used in Excel?

How to get the address of active cell in Excel?

How to hide / unhide all named ranges in Excel?

How to lock all cell references in formulas at once in Excel?

How to lookup/find values in another workbook?

How to quickly delete all named ranges in Excel?

How to remove time from date in Excel?

How to replace formulas with results or value in Excel?

How to resize an existing named range in Excel?

How to vlookup and return matching value with cell comment?

Developer

Developer > Controls

How to add custom button to the right click/context menu in Excel?

How to apply a button to clear specific cells in Excel?

How to apply a button to open another workbook in Excel?

How to auto-center checkbox in cell in Excel?

How to change a specified cell value or color when checkbox is checked in Excel?

How to change the color of ActiveX Control button in Excel?

How to clear contents of combo box with VBA code in Excel?

How to create a Command Button to copy and paste data in Excel?

How to create buttons to open/go to certain sheets in Excel?

How to create dynamic cascading list boxes in Excel?

How to disable button after clicking once in Excel?

How to display multiple columns in combo box?

How to enable or disable button based on cell value in Excel?

How to hide checkbox when row is hidden in Excel?

How to hide or unhide a Command Button based on specified cell value in Excel?

How to make checkbox checked based on cell value in Excel?

How to make Command Button name dynamic in Excel?

How to make the background color of checkbox transparent in Excel?

How to navigate between worksheets by using drop down list in Excel?

How to only make one checkbox to be selected in a group of checkboxes in Excel?

How to populate a combo box with specified data on Workbook open?

How to populate a Userform ComboBox with all sheet names in Excel?

How to populate Combo Box with data of Named Range in Excel?

How to populate combo box with unique values only in Excel?

How to populate textbox based on combobox selection on UserForm in Excel?

How to prevent or disable typing in a combo box in Excel?

How to quickly delete multiple checkboxes in Excel?

How to quickly insert multiple checkboxes in Excel?

How to remove or hide borders from group boxes in Excel?

How to save or retain selections of ActiveX list boxes in Excel?

How to tab out of combo box to select specific cell in Excel?

How to uncheck or deselect all checkboxes at once in Excel?

How to update or insert (current) date and time by a Command Button in Excel?

How to use a Command Button to change a specified cell value in Excel?

How to use button to show hide columns in Excel?

How to use checkbox to hide or unhide worksheet in Excel?

How to use checkbox to hide/unhide rows or columns in Excel?

How to use Command Button to save active worksheet as PDF file in Excel?

Developer > Macros

How to assign hotkey to specified macro in Excel?

How to automatically run macro when cell formula result changes?

How to create a macro code to achieve find and replace text in Excel?

How to run a macro at same time across multiple workbook files?

How to run macro automatically before printing in Excel?

How to run macro based on cell value in Excel?

How to run macro based on value selected from drop down list in Excel?

How to run macro by clicking hyperlinks in Excel?

How to run macro when cell value changes in Excel?

How to run macro when sheet is selected from a workbook?

How to run multiple macros by using a button in Excel?

How to run multiple macros from right click menu in Excel?

How to run the same macro on multiple worksheets at same time in Excel?

How to run VBA macro when open or close workbook?

How to use macro to insert row below table in Excel?

How to use time delay after running a VBA macro in Excel?

Developer > Others

How to click or double click cell to open a specified user form in Excel?

How to create a yes no message box before running a macro in Excel?

How to create pop up message box when opening an Excel file?

How to display warning/alert messages if cells are blank in Excel?

How to pop up a calendar when clicking a specific cell in Excel?

How to pop up a message box upon activating/opening a specified worksheet in Excel?

How to pop up message box if cell value changes within a range in Excel?

How to pop up message box if cell value equals “X” in Excel?

How to pop up message box to display range of cells or cell values in Excel?

How to pop up message box when clicking on a certain cell in Excel?

How to pop up the cell value while clicking in Excel?

How to populate google search results to worksheet in Excel?

How to show up an input box when clicking on a cell in Excel?

Mailings

How to automatically send email based on cell value in Excel?

How to insert signature into Outlook email when sending by vba in Excel?

How to quickly send email based on date in Excel cell?

How to send / email range of cells through outlook from Excel?

How to send a specific chart in an email with vba in Excel?

How to send an email at specific time of a day in Excel?

How to send an email through Outlook when workbook is saved in Excel?

How to send an email when the attachment Excel file is opened by the recipients?

How to send current workbook through Outlook from Excel?

How to send email if a certain cell is modified in Excel?

How to send email if button is clicked in Excel?

How to send email if due date has been met in Excel?

How to send email reminder or notification if workbook is updated in Excel?

How to send email to email addresses specified in cells in Excel?

How to send email to multiple recipients in a list from Excel via Outlook?

How to send email with copying and pasting a specified range into email body in Excel?

How to send email with HTML email body in Excel?

How to send email with multiple attachments attached in Excel?

How to send email with specified bold/size/color/underline text format in Excel?

How to send personalized mass emails to a list from Excel via Outlook?

How to send worksheet only through Outlook from Excel?

Others

How to check if a file exists in a specific folder?

How to check if a folder exists and if not create it?

How to highlight the active sheet tab in Excel?

How to increase a number automatically when workbook is opened?

How to insert countdown timer in Excel?

How to keep excel window always on top?

How to keep table expandable by inserting table row in a protected worksheet in Excel?

How to play video file from Excel worksheet?

How to repeat or loop a Macro every X minutes in Excel?

How to reset last cell in Excel?

How to reset scroll bar to default value in Excel?

How to scroll a specified sheet or all sheets to top in Excel?

How to set tab order of cells or unlocked cells in Excel?

How to skip cells or columns when tabbing in Excel?