Daily posts of Excel tips…and other stuff
Archive for the ‘Columns and Rows’ Category.
Hi everyone,
With all these Euler posts I thought, why not post my own?
Suppose the following:
I have a products table set up like this:
Code ProdName Price
0001 Product1 556.68
0002 Product2 977.41
0003 Product3 350.62
0004 Product4 509.16
0005 Product5 748.4
0006 Product6 802.96
(list goes on to as much as 5000 products)
And I want to show this table in a userform and give the user some filtering possibilities (lets say on the first two [...]
OK, time for some non Excel 2007 stuff…
Recently someone asked me if it was possible to transpose a table of cells, but in such a way that the formula of each cell is kept intact. I decided VBA was the way to go and produced a small but very useful little routine for that.
What the [...]
Sometimes I need to analyse data (row-by-row) in a worksheet with a lot of columns. Sometimes I then want to see information from a cell in a column way off to the far right together with a couple of columns on the left side of the sheet. Of course you can split the window, [...]
Otherwise know as Freeze Panes. This feature, under the Windows menu, allows you to lock certain columns, rows, or both in place so that they never scroll out of view.
Start by locating the split bars. I don’t their technical name, but it was either split bars or doohickies. I went with the [...]
Custom Views under the View menu is a quick way to hide/show unwanted columns (among other things). There are two situation in which I find Custom Views useful: First, if there are certain columns that I want shown, but not printed; and second, if there are columns/rows that will be hidden in the [...]
Bernie Deitrick showed a cool way to insert rows into a spreadsheet in answer to a newsgroup post this week.
First, create a new column A.
Next, fill numbers down for each row. Then copy those numbers to the blank rows below.
Sort on Column A
Then you can delete Column A and your done. Obviously it [...]
