Browser Based Excel
It looks like Microsoft is finally going to come out with a version of Office that will be made for your internet browser. Like Google has done with Google Docs, Microsoft announced its plans at the Professional Developer Conference (PDC) to put lightweight versions on Excel, Word, Powerpoint and OneNote online that you can pull up [...]
Excel Hints is Giving Away Over $1400 in Prizes
Excel Hints is very excited to announce our First Contest Giveaway! We want to say thank you to all of our loyal readers as well as welcoming new visitors by offering a chance at some great prizes. And we have over $1400 of prizes!
Prizes
Between now and the last day of November, we will be accepting [...]
Protect Cell Formats
I received a comment from a reader the other day asking this question: How can I protect the formatting of a sheet without preventing changes to the cell contents? In other words, she wanted to the sheet’s users to be able to be able to type in numbers, but not mess up her border, fonts [...]
Count Rows with Data in a Macro
For this Excel tip, let’s look at an easy way to count the number of rows containing data in a spreadsheet. One way would be to do use a for loop and a counting variable, but that contains unnecessary steps to get the job done.
A simple way to count the number of rows in a spreadsheet is [...]
Using a For Loop in a Macro
If you’re new to macros, you might want to check out a previous post I made Familiarizing with the Visual Basic Editor and Use the Record Macro Feature. Basically, the purpose of a macro in Excel is to provide you with a way of quickly and easily modifying the values in your spreadsheet. Actually, there are [...]
Loading ...