Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Excel Tips: Developer > Macro or VBA

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?