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?