Cracking the Mystery of Custom Number Formats in Excel. Excel has many built-in formatting options that you can apply to your information. These range from Number, Currency, Accounting, Date, Time, Percentage, etc to name just a few. But what do you do if you cannot find the exact format you want to apply to your information? Why you create your own custom format that’s what. To create your own […]
13 Keyboard Shortcuts for Data Entry in Excel The key element in entering data into Excel is completing the data entry by either clicking from one cell to another cell with your mouse or by using one of the keyboard shortcuts listed below to move to another cell. Data entry into a spreadsheet is a very manual process and is still predominantly carried out using a keyboard. It […]
Do you need to Merge that? There are a number of “basic errors users make in Excel” that results in their spreadsheet life being that much more challenging when it doesn’t necessarily need too. One of these, which we are discussing today, is the use (or unnecessary use) of merged cells in an Excel spreadsheet. Why Merge Cells? Merging cells in a spreadsheet is a process that […]
D.A.R.E. to be different! A common misconception when it comes to learning about Excel and how to use it is that it is all about how do I use and implement all these functions and their capabilities. This misconception is further compounded by the fact that most Excel training just simply teaches you new functions and capabilities and does not dive into the VERY important stages that you need to […]
Hide Gridlines in Excel Knowing how to hide gridlines in Excel is a common task that makes your spreadsheets clean, presentable and have a more professional look and feel. What are Gridlines? A spreadsheet contains cells and gridlines represent the borders of these cells. They are the faint lines on your spreadsheet that help you to distinguish a cell’s boundary. By default, gridlines are displayed in your spreadsheets using a […]
I was asked recently by a colleague of mine “is there a way in which we can make a cell flash in Excel to highlight some pertinent information?” The idea behind the question was that the data in the spreadsheet is entered and maintained by an employee and then provided to their boss to actually work with the information. So… was there a way in which to highlight areas in […]
