FileCatchers - Utilities & Guides

EXCEL – Highlight Active Row/Column when Cell is Selected (VBA)

Think that you have loads of data with many rows and you need to check them daily for details, or add new data. You might miss things after concentrating on many rows too much time, clicking on a row and reading data from the row above or…

Guides

EXCEL – Highlight Active Row/Column with an Underlining Shape (VBA)

Highlight the selected row/rows and column/columns with an underlining shape (line, rectangle etc.).

Guides

Excel – Extract Weather Information to Excel Ranges using VBA

Extract weather information for your hometown for today and the next 8 days directly to Excel cells, by clicking 1 button. This works for over 22.000 cities all over the world by using a free weather API.

Guides

Excel – Force Uppercase Text in a Column

Forcing uppercase text in a column is sometimes useful if multiple users work on the same file and you want to make this condition by default. Either show an error when they don't insert UPPERCASE text, either make the text UPPERCASE…

Guides

Excel – Create a PERSONAL.XLSB File to Store Macros

If you are using Excel VBA you might know this already. Storing macros that work in any Excel file can be done in 2 ways: Creating a macro enabled binary file (PERSONAL.XLSB) that loads when you open any Excel file. Normally Excel…

Guides

Excel – Formula to Display the Current Worksheet’s Name

Display the current worksheet's name in a formula and its result changes if the name of the worksheet changes.

Guides

Word – Count Table Cells in Selection

Count cells in Word table selection with the press of a button. It comes handy when pasting a range of cells from Excel.

Guides

Excel – Automatic Update of Sequence Number / Current Number in a Table

Do automatic numbering of rows in a Table (SQN, Cur. No) with a formula that reacts with Excel rows instead of cell ranges or values. This automatic numbering updates itself never showing an error and regardless of Table sorting.

Guides

Excel – Copy Above Row to Multiple Rows Below

Select a desired range of cells and paste the row above the selection into those cells by the press of a button instead of manually copy/pasting the data.

Previous 1 … 24 25 26 27 28 … 40 Next