(1)  In the "top 10" dialogue box, there is a choice between "items" and
"percent."  I understand "items" but not "percent" which may return more or
less rows when chosen.
(2)  On the bottom left of the worksheet, it shows "xx of xxx records found"

I've downloaded a document from Notepad to Excel. How can I format it to
different columns, or utilize the way  it is now and it would print out each
line without cutting off portions of each line?

First time poster here.
Here is the situation.  I am working on the finishing touches of m
companies' financial model which projects future revenue, income, etc.
Anyways, one of the inputs for the model is a collections rate.  W

I need to create a macro which will automatically number a range of
tickets in "cut-stack" order. Another way this might be worded is,
given "nnn" sheets of paper, the order of each ticket number is
sequential on each subsequent sheet of paper. When the paper is cut the

I am importing a text file that has a lot more than 256 columns. The
data will be updated weekly with a different text file. I know how to
get past the 256 column limit when importing a text file like this.
This link explains the method I am using to import the text file.

What I want to do is record a macro and then have a button on the
spreadsheet to click that will run the macro.
The macro itself will cause a Solver to be run so it only has to open
the Solver and input 2 predetermined cells and one predetermined hard

Well, I guess the title says it all... Locking a sheet from being
deleteable!???
Thanks / Jennifer

why do you guys use excel?
how do you survive the 65k row limit?
it just boggles my mind; i hate excel more than anything
i think that all your spreadsheet dorks should be homeless; on the side

I am using Office XP.  I have been asked to track employee receipts for a
small daycare/elementary school.  This is our first year to implement this
feature for about 30 teachers/employees.  Each person will be allowed $500
for the year.  I must record their receipts and be able ...

Re : Excel Range of Values Amidst Characteristic Transitions
Enter an Excel worksheet ; now that the tabulation is prepared for
(preferential) presentation, Column A is shown as follows :-
01  8.0

How do I get the info in a cell on one worksheet to update the same info in a
cell on another work sheet?

...I hope. I just started doing my own VBA Programming and I'm stuck.
I've created a formula that is just a series of nested ifs (12).  I'd
like to be able to dragged the cell containing the formula and have the
REF change as I drag it, but right now the formula is not variable and

Created Excel document. Print preview did not show gridlines. In attempting
to get gridlines, somehow got into charts. A chart was created and is
superimposed on original document. How do I get rid of the chart? How do I
get gridlines on to original document?

I am on salary (weekly) but always work alot more than 40 hrs per week.
How can I make a spreadsheet that will calculate my rate of pay on a weekly
basis, by me typing in the hours worked per week(ex; 40 reg  + 20 overtime)
Please Help,

I'm writing some code in Visual Basic and want to to be able to name a
sheet today's date whenever the macro is run?  Is there a way to do
this?