Hello Excellers, welcome to another #formulafriday blog post in my #ExcelTips 2021 series. First, let's look at how to see your Excel formulas. It is done more (or less) by resizing the Excel Formula Bar for Excel. Does This Work In All Versions Of Excel?. In versions of Excel earlier than 2007, editing a cell that has a lengthy formula or a cell containing lots of text is not easy. It can often block part of your worksheet. In Excel 2007 onwards, it addressed in … [Read more...]
Formula Friday -Delete Values From Cells While Keeping Formulas.
Hello, Excellers, and welcome back to another Excel #FormulaFriday blog post in my 2021 series. Today let’s look at how to delete values from cells while keeping the formulas. A popular way to set up an Excel spreadsheet is to have input cells (which the user changes) and formula cells that work in tandem with those user input cells. But, what if you want to delete all of the data in cells but keep your formulas intact?. You can by using the GoTo special feature in Excel. So, of course, there … [Read more...]
Create A Timestamp In Excel With Formulas
Do you need to insert a timestamp in Excel to track something?. This is a very common question for Excel users. Table of contentsWhats Is An Excel Timestamp?Use TODAY and NOW Functions To Insert An Excel Timestamp.Circular Formulas Explained.Iterations Setting.How The Excel Formula Works.Other Recommended Reading. Want More Tips? Whats Is An Excel Timestamp? So, under lots of circumstances, would you enter the date on a spreadsheet for an entry onto an invoice, a project plan, … [Read more...]
Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function
Happy Friday Excellers. Today let's look at how to generate unique user names in Excel using the COUNTIF function, even when you have duplicates!. Welcome back for another #FormulaFriday in my #Excel 2021 series of Excel blog posts. I have used this formula to generate usernames for a database. Sometimes there is more than one person with the same name. This great formula in Excel will help us get over this issue by generating unique user names. Here is a list of usernames that has … [Read more...]
Formula Friday – Two Ways To Highlight Today’s Date In Your Excel Dataset
Hello, Excellers. Welcome to another instalment of #formulafriday. Today let's look at here a handy Excel Tip if you want to highlight today's date in your Excel data set. I have found this really useful visually where I have sequential dates and want to see where today's date sits in the sequence. You can see from my example data set below, I can easily see today's data with some simple conditional formatting. (..and today's date is 28/12/2017) There are a few … [Read more...]
- 1
- 2
- 3
- …
- 54
- Next Page »
Recommended Excel Resources
