Skip to main content
Excel Macro: List Files From Directory Order By Date Modified
FileSystemObject does not order files, we can order files by Dir command. If you don't need to sort files, use FileSystemObject. First, we […]
Excel Macro: List Files in Subfolders, Version 2
This Excel macro can list files in a specified folder and subfolders, and you can filter multiple file types. The difference from […]
Formatting Tools for Excel
The Excel cell formatting tools are available in three locations. On the Home tab of the Ribbon On the Mini toolbar that […]
Basic Formatting of Worksheets
Using fonts to format your worksheet You can use different font, font size, font style, font color, and text attributes for your […]
Using Cell Styles for Easier Formatting
Cell styles combine a number of different formatting aspects that can include number format, text alignment, font and font size, borders, fills, […]
Understanding Cells and Ranges
A cell is a single element in a worksheet that can hold a value, some text, or a formula. The basic unit […]
Insert or delete rows, columns, and cells
You can insert and delete one or more cells, rows, or columns to organize your worksheet better. Note Microsoft Excel has the […]
Hide or Unhide Columns and Rows
You can hide rows or columns that contain sensitive data. In some cases, you may want to hide certain rows or columns […]
Resizing Rows and Columns
Rows and Columns default width The table below shows the minimum, maximum and default sizes for each based on a point scale. […]
Select Cells and Ranges In Excel
You may want to select multiple cells, ranges, rows, or columns in a worksheet in order to format the data in the selection, or to […]
Move or Copy Ranges
About move or copy ranges Using move or copy range you can do: Copy a cell to another location. Copy a cell […]
Working with Comments
Comments are like yellow sticky notes in a spreadsheet. They're useful for reminding yourself of what you've done, or for explaining changes […]