Browsing Category
Guides
Do things you didn’t know were possible. Do regular things better, quicker.
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.
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…
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…
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.
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.
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.
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.
How To Improve Your Battery Life on Windows 11
The last thing you want is for your laptop to die in the middle of a crucial work project or a Zoom video chat, yet it does happen, despite your best intentions. It's ideal to keep your computer plugged in all the time, but if you don't…
Portable Hasleo Windows ISO Downloader 1.0
Hasleo Windows ISO Downloader is a small application that can help us to download Windows installation 8.1/10/11 ISO from Microsoft's official website. It's completely free, small and doesn't require us to install it, such a small and handy…