Have you ever experienced data entry in a workbook that jumps around the place, or you want users to enter data in a specific order?. Excel CAN force the sequence of cells that you want users to select. This solution relies on defining a named range which essentially is a sequence of cells that you specify. See below as an example of the sequence of cells that I want users to type into Excel. So let's give this a go. Click in the cell that is second in your required … [Read more...]
Sorting Excel Data By Colour
by Barbara

Excel allows you to sort your data in many ways, but with Excel 2007 onwards we can now sort easily by the font colour or by the cell fill colour. It is easy and effective and is available as a custom sort function. Select the data you want to sort Data Tab Sort And Filter Group- Sort Use drop down menu in the Sort On Column and select to sort by either the font or cell colour Using the drop-down list in the Order column, select the color by which you want to sort. (Excel allows … [Read more...]
Quickly And Easily Import Data To Excel From The Internet.
by Barbara

If you have ever used data from Yahoo or Google in a data table have you retyped it in, or tried to copy and paste it? It either takes too long or the formatting appears all over the place. Google is an excellent source of information you can analyze using Excel, I just do not want to retype it or copy it! You don't need to to, you can import the data into Excel as long as the data is formatted on the web page as a table. Here's how to do it:- Open an Excel … [Read more...]
Why Is Excel Changing The Last Digit Of My Number To Zero?
by Barbara

If you have ever come across this it can be confusing and damn frustrating, you type a long number into Excel and weirdly anything past digit 15 is placed as zeros. So if you are typing a credit card number, which are normally 16 digits then the last is displayed as a zero. This is because Excel only stores 15 significant digits in a number, then changes the any remaining to zeros. This occurs because Excel interprets the numbers as being intended for calculation as the cells are formatted … [Read more...]
Format Individual Characters In An Excel Cell
by Barbara

In Excel you aren't restricted to having your whole cell full of text formatted in the same way. You can have individual formatting on different characters within a cell. (This only works with cells that have text only!) . This is a nice way to emphasize a point you are trying to make or jazz up a workbook- why not??? Here is how Select the cells you want to format in the usual way Use the usual formatting controls to format your individual characters Here's a couple of examples:- … [Read more...]