how can I freeze column width (cell size)???
I have a spreadsheet with formulas.
I show the formulas and resize (autofit) the columns.
I want to freeze the column widths on all the columns then...
.... uncheck show formulas.
Problem: when I uncheck show formulas the columns resize (smaller)
Many of the columns re-size to small for the data (pound signs display).
Can someone tell me what I need to do to keep the columns from resizing
after unchecking show formulas?
How about a little macro?
Dim myColWidths(1 To 256) As Double
Dim iCtr As Long
With ActiveS...Column heading differences
The menu column headings on my spreadsheets today are numbers instead of
letters! I want the letters back! I like the differentiation between rows
(numbers) and columns (letters). Help??
I received and opened a virus-free spreadsheet from a co-worker. Her
spreadsheet had numbers for the columns -- could that have made my default
switch? How do I switch it back?
<Tools> <Options> <General> tab,
And *UNCHECK* "R1C1 Reference Style".
Please keep all correspondence within the Group, so all may benef...sort 2 column in the same time "" as dictionary ""
I need to make sort of pages to be like a dictionary
is that possible
I put a test file on the next link
I need to sort the 2 yellow column ,to be alphapetic page by page
appreciate for help me
...Reversed column labels
For some reason, when I open any new spreadsheets, the column labels are
reversed, with column A on the right side of the screen. This is making
working with excel difficult. Is there some option I enabled that can be
disabled so that Excel gets back to normal?
tools / options / international - check the settings under default direction
note, you won't see the affect of this until you close & reopen your
"Drew Remsen" <firstname.lastname@example.org> wrote in message
news:MeSpd.73932$8G4.email@example.com....Sort numeric data in more than 3 columns in excel
I have to sort 12 columns of numeric data in descending order on a
excel worksheet. I currently sort 3 at a time and then move forward.
For example, I have sales data for months Jan to Dec. I want each of
these columns to show zeros at the bottom when the macro is run. The
rows would increase in future but the columns would be fixed. The
worksheet would also remains unchanged each month. None of these
columns are of least significance.
Is there a way I could change a recorded macro to achieve this?? I know
very little of VB. This would be of great help!
All of the columns ...Group rows / columns: +/- symbol at top or to the left?
If you group columns or rows, you will see a little symbol "+" or "-"
to indicate the grouped section.
I am wondering if there is a way to tell excel to display the symbol on
the top of the grouped section (instead at the bottom in case of
grouped rows) or to the left (instead to the right in case of grouped
Help greately appreciated!
Data/Group and Outline/Settings...
In article <firstname.lastname@example.org>,
> If you group columns or rows, you will see a little symbol "+" ...how to highlight current row & column automatically by a color
I'm using Excel 2003, can u plz help me out that how to highlight current row
& column with a color automatically to identify my position. Though excel
help us by highlighting column & row number, but i want whole column & row to
be highlighten to better finding my cell position and contents. So When I
change my cell position, the highlighted row & column move appropriately.
Take a look at
In article <4076508D-B500-4491-8BE9-C70A825EEBC2@microsoft.com>,
asif4u <email@example.com> wrote:
> I...Move Column Data into a row
I have text in a column that I want to move into a row instead, is this
possible without typing it all over again?
avidcat's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29659
View this thread: http://www.excelforum.com/showthread.php?threadid=493706
Copy the data and then do a Paste Special using Transpose.
wrote in message
I am having a little problem and I was wondering if any of you coul
help me with it. I have two columns, A (Definitions) and B is empty.
Column A has several words in a single cell, I was wondering if ther
is a way to put only the first word from cell A1, for example, in cel
Message posted from http://www.ExcelForum.com
Norman Harker MVP (Excel)
"marksuza >" <<firstname.lastname@example.org> wrote in message
Outlook is not remembering my e-mail password. Have to
enter them everytime I start the program.
...Sorting several columns
I'm trying to sort a sheet, sorting first by column A, then B, then C
It works fine half of the sheet, but then column C isn't sorted correctly.
Data format is the same, so that's not the problem.
In column C sorting I've made my own list to sort by (st, 1, 2, 3, 4), and
it works fine the first 20 rows.
Then it only sorts correctly in column A and B
A B C
AA 1A st
AA 1A 1
AB 1A 1
AB 1A 5
AB 1A st
AB isn't sorted correctly according to the list I've made in the ...Column widths
I have developed a great sheet with 4 separate SQL queries to give users a
All works wonderfully except that each time the sheet auto-refreshes, my
column widths compress down which makes the sheet hard to read.
Is there a way to lock down the colum width so it doesn't change?
You could try un-checking 'adjust column widths' in 'Data range properties'
by right-clicking on the external data table. You could also, if this
fails, put some code in the Worksheet_Change() event like so
Private Sub Worksheet_Change(ByVal Target As Range)
Columns....Problem with referencing a hidden column
The code below works great, that is until I hide column Q. I do not want
the data in column Q to me visible on the worksheet. Is there any way around
TextBox100.Value = Range("Q4").Text
TextBox200.Value = Range("Q49").Text
TextBox300.Value = Range("Q94").Text
TextBox400.Value = Range("Q139").Text
TextBox500.Value = Range("Q184").Text
TextBox600.Value = Range("Q229").Text
TextBox100.Value = Range("Q4")
"ordnance1" <ordnance1@comcast...Deleting columns
Has anyone had this problem:
I have a spreadsheet with multiple tabs. On the first tab I can selec
a group of cells within a column, lets say B12 -- B45 and right click o
them, get the option 'Delete...' and it asks if I want to shift left
up, entire row, or entire column. Now, on the second tab I select th
same group of cells except now when I right click it will only let m
Any ideas as to what I am missing here
surg4u1975's Profile: http://www.excelforum.com/member.php?action...print 4 alternate columns
yesterday, 29th, a helpful person assisted me in solving - printing a column
and a selected area - that was fine and successful.
now, what happen when I wanted to print alternate columns only - i tried
ctrl+selection on alternate columns & use the Print Option - Print Selection
- but I not able to view it in 1 page & I also used the Print Option (At the
Sheet Tab area) - selected the "Repeated Columns on Left" - and use the Print
Area command - yet not able to get the alternate columns to view as 1 page to
can any body assist me on this ?
...Outlook Express #256
Is there any way to set outlook express to leave a copy
of the message on the server and leave it marked as
Taylor <email@example.com> wrote:
> Is there any way to set outlook express to leave a copy
> of the message on the server and leave it marked as
Ask in an Outlook Express newsgroup.
...Hidden column is visible on reload
I'm having a form with a DataGridView control in it. I'm facing a
problem with a column which is set to be hidden in the designer.
While I view the form for the first time, it is hidden. But when I
load the form again, this column gets visible and shows in UI. For
that I tried to explicitly set this column to be hidden on form load,
but still the problem persists...
I'm using DataTable to bind the data to the DataGridView.
What might be the possible problem with it? How to check the property
and when it gets changed? Still more annoying is that, I've one more
fo...How to create combo box on whole column fastly?
How can I create combo box on one whole column fastly?
Please let me know, thanks.
accessman2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27953
View this thread: http://www.excelforum.com/showthread.php?threadid=474563
Here is a fastly code:
Dim ListItems As Variant
Dim i As Integer
ListItems = Range("A1:A1000").Value
ListItems = Application.WorksheetFunction.Transpose(ListItems)
With CB1 'CB1 Stands for ComboBox1
For i = 1 To UBound(Li...Mailbox Size Limitations
I have successfully setup the mailbox size limitations and it works fine.
However, I wanted to know where I can change the actual message that is sent
to the users. For example, this is what is sent:
Your mailbox has exceeded one or more size limits set by your administrator.
Your mailbox size is 458823 KB.
Mailbox size limits:
You will receive a warning when your mailbox reaches 453000 KB.You may not
be able to send or receive new mail until you reduce your mailbox size.
To make more space available, delete any items that you are no longer using
or move them to your personal folder fi...Inverting rows and columns
How do invert rows for columns so i can sort information
by columns not rows
Edit / Copy then Edit / Paste Special / Tranpose
or you can simply sort left to right - look in the options on the sort
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
"Robkis" <an...Convert row data into column data
I have a row of data that I want to arrange in a column.
I have a about 25 cells in 1 row with data.
I want 25 cells in 1 column with the data.
Is there an easy way to convert the row into a column?
I thought I saw how on the newsgroup, but can't find it now.
Lunker, select the cells, then Edit > Copy. Select a destination cell, then
Edit > Paste Special > Transpose > OK.
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com
"lunker55" <firstname.lastname@example.org> wrote in message
Using Arrange, Layout Guides, I set up Publisher 2002 with two columns per
page and with two master pages with mirrored guides.
For the first 11 pages, text flowed as expected. That is, each new pair of
pages had two textboxes per page.
But now, when I add a pair of pages, Publisher gives me guides for two
columns per page but gives me only one page-wide textbox per page, not two.
How do I force Publisher to give me two textboxes per page, as it did for
the first 11 pages?
(I might be missing something obvious. I haven't used Publisher in several
After mana...Value Limits In A chart
Is there any way possible to change the color of a data series within a chart
when it exceeds a value of another data series?
"Robby" <Robby@discussions.microsoft.com> schrieb im Newsbeitrag
> Is there any way possible to change the color of a data series within
> when it exceeds a value of another data series?
> Tha...column heads
How do I designate an entry as the column head/label/name vs. data entry?
In what context?
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"4most" <email@example.com> wrote in message
> How do I designate an entry as the column head/label/name vs.
> data entry?
I am creating an elementary spreadsheet, and I want to place headings at the
top of each column.
"Chip Pearson" wrote:
> In what context?
> ...Transferring a two column excel file into outlook
Is there a simple way to transfer an excel file which has two
columns ,one for names the other for phone numbers, into my outlook
address book? I have a excel file with over a hundred such entries
and would rather not enter them individually, surly there is a simple
way to do this. Any suggestions?
Condo <theCONDOmanager@gmail.com> wrote:
> Is there a simple way to transfer an excel file which has two
> columns ,one for names the other for phone numbers, into my outlook
> address book? I have a excel file with over a hundred such entries
> and would rather not enter them in...