Excel, how do I change the column headings from letters to number
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lazybee" <firstname.lastname@example.org> wrote in message
>I have a spreadsheet that has numbered columns as opposed to the
> letters. How can I change this ...Hiding empty rows and columns
Does anyone know the code for hiding all blank rows and columns
in a worksheet.
Message posted from http://www.ExcelForum.com
try the following (adapted from:
Public Sub HideBlankRows()
Dim R As Long
Dim C As Range
Dim Rng As Range
On Error GoTo EndMacro
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
If Selection.Rows.Count > 1 Then
Set Rng = Selection
Set Rng = ActiveSheet.UsedRange.Rows
For R = Rng.Rows.Count To 1 Step -1
If Application.WorksheetFuncti...Re-print SVC RTV Packing Slips
Please add to the Reports Menu the ability to Reprint a RTV packing slip.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=107decaa-6e0a-4bc...Excel moving horizontal columns to vertical
I am trying to find a simple way of moving data in horizontal columns
(referencing the key in column 1) to vertical colums (still referenceing the
same key). This would mean automatically repeating the values in column one
for every entry in the moved columns.
I can do this through the pivot table, but this is a long drawn out process.
I'm not sure if this will work for you, but you can try this:
- Highlight & copy on the horizontal value you want to make vertical
- Now highlight the vertical area you want these value to got
- Right Click when highlighted & choose...Select all of a certain column across multiple worksheets
Is there an easy way to simultaneously select (or do a find-and-replace) on
column H on every worksheet of an entire multi-sheet workbook, without
having to select that column on each individual worksheet by hand?
Right-click on first sheet tab and "Select all sheets"
In activesheet select the column............will be selected on all sheets.
Gord Dibben MS Excel MVP
On Mon, 24 Aug 2009 16:43:02 -0700, "Charles Belov"
>Is there an easy way to simultaneously se...How to make a Add key disabled after adding one record unless
I have a form where I am adding records. There are two boxes where one has
to put the lineitemnumber and another box where one has to put the
description. Unless the above two boxes are filled in the Add command box
need to be disabled. Now, the problem is after adding one record the Add
button is enabled and I cannot disable it. I would appreciate any help to
The error message is:
The methos is not supported
The following is the code:
Private Sub cmdadd_Click()
On Error GoTo Err_cmdadd_Click
If (IsNull(Me.LineItemID) = True) Or (IsNull(Me.Description) = True) Then
...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email email@example.com ��and
windows2003 + exchange 2003 Server "B" firstname.lastname@example.org user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...How can I print just the flip side of a booklet?
How can I print just the flip side of a booklet? I printed the first side
just fine and then my computer went funny and I had to shut down and start
back up again. I have 25 copies of the first side that need to be printed on
the back side.
Pub 2000 user here:
There may be a better way but I think you will have to print a page at a
time i.e., File, Print Page 2 of 2; then 3 of 3 and so on.
"pqc18" <email@example.com> wrote in message
> How can I print just the flip side ...Transformation of data into columns
I have the data from a flattened spreadsheet in a table in the
f1 f2 f3
period to: Scheme1 Scheme2
31/01/2005 Net Gross
28/02/2005 Net Gross
31/03/2005 Net Gross
30/04/2005 Net Gross
31/05/2005 Net Gross
30/06/2005 Net Gross
31/0...Mail Merge Printing collated
When I print a mail merge (I don't use it for mailings and envelopes),
Publisher prints out the first 5 records as an individual document then the
next 5 as a seperate document, and so forth. Since I often need to make
multiple copies of these documents, I end up having to collate them by hand.
How can I get Publisher to print the entire merge as one document before
printing the second, third, copy? I believe when I had P'03 it would print
that way, but when I upgraded to '07 this problem started.
You can't... Maybe later with a service pack these printing bugs will b...Messenger emoticons
I have changed laptops and I did grab the old laptops custom emoticons
folder (all in dt2 and id2 file endings.) But when i copy everything in
the folder and add it to my new laptops custom emoticons folder... they
get added (i.e. show up in the folder) but the images/gifs or names dont
show up on the actual msn... *what gives*?
Do I have to change the dt2 endings to gif or jpeg and go to "create" in
msn for each of them to add them in? (I tried with one and it worked)
Only problem is i have alot, like 203 dt2 files so changing the ending
to .gif and adding each singu...MS Excel Print setup
When i save a document by using landscape setting,& by
opening again that document it does'nt show saved setting.
It shows portrait option,not landscpe option.
...Is there a way to sort a column without invoking a macro?
I am trying to get a feel for some probabilistic properties. For
example, I am trying to look at the statistics of the intervals between
randomly occurring pulses. I have no problem getting a column of
uniformly distributed pulse times, but they are unsorted, Every time I
recalculate with cmd-=, I get a new unsorted set of pulse times because
of the use of the RAND function.
Is there a way of taking this unsorted column and pasting it into
another colun that would be sorted without invoking a macro?
To simplify and be more specific consider the following.
1. In A1:A100 I have a set...How do I print 4 postcards to one page to match my postcard paper
I bought perforated postcard paper that has 4 postcards per sheet. How do I
create that in Publisher? I created it exactly how I want it to look and
then realized it's only printing 2 per page.
Which version of Publisher are you using?
MVP Microsoft [Publisher]
How to ask a question
"Lauren" <Lauren@discussions.microsoft.com> wrote in message
>I bought perforated postcard paper that has 4 postcards per sheet. How do
>...Chart printing issue in Excel 2007
A spreadsheet with charts was created using Excel 2003. I have Excel 2007
and saved it in compatibility mode.
I inserted a couple colored lines on the chart and created my own legend
based on these. A couple of issues:
1. When I close the file or even minimize, 2 of the colored lines on a
couple of my legends disappear upon reopening.
2. When I try to print a chart, it looks good in Print Preview, but then
looks magnified,half off the page, and only one of my drawn lines is printed.
When someone with 2003 prints, the sizing is correct, but all of the
colored drawn lines are missing...Can I do this query in one step?
Suppose I have a talble like this, each record has a unique ID. All"A"s or "B", "C"s should have only x or y or z property attached. Iwant to find A, B or C which has more than one properties.1 A x ...2 A x ...3 A x ...4 A y ...5 B x6 B y7 C z....resutls would look like:A xA y....I think I can do this in two steps or with a subquery. Then I thoughtof self-join but didn't figure out how to use it in this case.Thanks a lot! SELECT DISTINCT and do not include the record ID perhaps? Or is the record ID vital?"muster" <firstname.lastname@example.org> wrote in me...unique with 2 columns
I have 2 columns with duplicates in the first column and no duplicates in the
second. I neeed to only see one value for each in the left and only one of
the accounts from the right.
ie: abc 1234
I would like to see either of the abc with the 1234 or 12345
I would like to see the bcd since it's individual with the 251
I would like to see either of the eft with the 600 or the 607
Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the...How do I print a SINGLE POSTCARD on 5.5x4.25in stock?
I have a preprinted postcard that is 5.5" x 4.25". A standard postcard. I
cannot for the life of me to get Publisher to print on this cardstock!! It
keeps thinking the page is "LETTER 8.5x11".
I have NO problems getting 4 cards (multiple addresses) to print on one
page. But now I have the cards pre-printed and just want to mail-merge an
address list onto them.
How do I set this up? Because apparently, using the post card template of
5.5x4.25 (or even the 6x4) doesn't do it!!!!!
Thanks for any insight.
Here select your stock si...Visio Printing Problem
I am trying to print a flowchart. The print view displays the complet
flowchart. However, when I print the flowchart, the top half of th
flowchart is omitted and the bottom half prints. Any problem solvin
recommendations would be appreciated
jqsandman's Profile: http://www.officehelp.in/member.php?userid=661
View this thread: http://www.officehelp.in/showthread.php?t=136719
Posted from - http://www.officehelp.i
this usually ends up as being "apply available software patches to visio" or
&quo...Column and Line Chart
I am making a Custon Chart using the First -Column and Line Chart. When I
setup the chart it makes the last column a point instead of a column. When I
go in to change the type of Chart it makes the bar much bigger than the
others. I know you can go into Format and decrease/increase width- but I
can't believe there is a not a way to tell excel to make this a column on
setup so they are all uniformly spaced. How does Excel decide whether it is
a point on a line or a bar?
Hi Nikki -
Excel simply splits the number of series between the lines and columns. If you wa...Object error when trying to print custom reports
I am getting an [object error] message when trying to print custom reports
or modified versions of canned reports. They display just fine within CRM,
we just can't print them. I have already tried deleting the ActiveX to
force a reload and manually reinstalling it using
http://crmserver/viewer/activexviewer/en/npviewer.exe with no luck. This is
occuring on systems regardless of whether Crystal Designer is loaded.
Open the reports in Crystal that you are having problems with and make sure
that the "Save data with reports" option is not checked. (In Crystal...I have individual place cards I want to print can anyone advise m
I am helping friends print their wedding place cards, they have been given
the individual cards from the place where they are having the wedding, but we
cannot get them to line up
What are the size of the place cards? Are there more than one card on the page? Are
you merging information? What version Publisher are you using?
Mary Sauer MSFT MVP
"Pauline" <Pauline@discussions.microsoft.com> wrote in message
>I am helping friend...Merging seperate workbooks into one workbook
I am looking to merge a bunch of workbooks with one sheet in each of them
into a single workbook with a bunch of sheets. All of the files are in the
same folder. Once upon I time I downloaded a utility from microsoft.com that
did this in a snap, but I cannot find it. Does anyone know where I can find
that utility or how I can do this?
Regards Ron de Bruin
"Raoul Duke" <RaoulDuke@discussions.microsoft.com> wrote in message news:86D64287-6247-4FD6-9CFB-F...A Strange Printing Problem
Our accounting department maintains an Excel file, updated in an onging
process, converted to a PDF at month close, and distributed to our senior
There are nine worksheets, seven behave normally, but two worksheets default
to printing 2 copies.
No macros, viruses, etc.
Any suggestions on a fix will be appreciated.
I would try a different PDF converter. There are a # of free ones out there.
It would be a simple and quick test to see if that was the problem.
> Our accounting department maintains an Excel file, updated in an onging
> process,...Extra word prints that does not show when viewing the document
When I print my document or view it, this extra word is not there. When the
document prints, this hidden word is in the printed document. How do I find
this hidden word and delete it?
If it prints, you know where it is. Have you turned on your nonprinting
characters, etc? Have you tried copying and pasting it into a new blank
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"S Roberts" <S Roberts@discussions.microsoft.com> wrote in message