Column Headings #11
Can you add seperate column headings (A, B, C, ...) into one spreadsheet?
I'm attempting to alter the column sizes half-way through the spreadsheet
w/out affecting the upper column sizes...
Coolumn width belongs to the entire column and cannot be altered in separate
sections of that column.
Gord Dibben Excel MVP
On Tue, 8 Mar 2005 15:51:01 -0800, spencer4hire
>Can you add seperate column headings (A, B, C, ...) into one spreadsheet?
>I'm attempting to alter the column sizes half-way through the spreadsheet
>w/ou...Text to columns
Once I use the Text to columns feature in Excel, it seems there is no way to
turn it off.
Anyone know if there is a way to reset this so that newly pasted text will
not continue to get broken up (for example by the space delimiter)
Presently the only way is to exit Excel and restart Excel - then pasted text
all goes into one cell regardless of spaces.
Hope I explained that well enough
I may have been to hasty in making this assumption, it appears that the
problem I described below is only happening on one workstation - this may
indicate that the Excel Registry keys are in need of...Column Reference to External Source As a Variable
Can anyone help me convert the column referenced in the formula below into a variable that the user can define?
More specifically, I have several columns that I need to read from an external workbook (Short_Billy.xls). Each column to the right of column C represents an additional day out in a 14 day projection from today (whose data is held in column C).
In cell I5 of my active workbook (Inventory.xls), I would like the user to be able to enter a value representing the number of days out they would like to see the projection for (0=today=Column C, 1=Tomorrow=Column D, etc.). In cell I6, I...Deleting "mail to:" email address links
I have a relativly straight forward spreadsheet where I
am maintaining a large address list. It contains a
homeowner's lot number, name, address, telephone #, and e-
mail address. When attempting to select random cells for
data entry/modification, I receive and automated
message " mailto: (a random e-mail address) - click once
to follow. Click and hold to select this cell."
I have no idea where/how this message/feature/function is
being attached to these cells but would like to eliminate
it. Since seeing these messages, the size of the
worksheet has been increasing in ...How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?
Just run another data|Text to columns against a dummy cell.
Specify delimited, but remove all the check marks from all the possible
(alternatively, you can close excel and reopen it.)
> I've noticed in Excel 2000 that if I paste text into various worksheets
> within a workbook each paste will assume the Text->Col...Cannot delete report
I have install the report manager sometime ago, it is working fine.
Until recently we found that when i click the action menu, nothing is come
out. I can't delete or rename the report. But I can add new report.
Do anyone encouter this before?
...Excel 2003 Copy/Paste filtered column
I have a filtered column on my spreadsheet. I have copied the column,
changed the figures and then tried to paste it back on to the filtered
column. It is not copying over the original filtered column but rather over
cells that have been filtered out. The worksheet/cells are not protected.
What could the problem be?
That's the way pasting works. It'll hit the visible and hidden cells.
> I have a filtered column on my spreadsheet. I have copied the column,
> changed the figures and then tried to paste it back on to the filter...Right click in Pivot Table or on Entire Column
I have added items to the right-click menu that popups up when you have a
cell or cells selected. But when you are in a Pivot Table or have an entire
column selected the right-click popup is different.
Is there a way to add an item to the right-click popup menu when you are in
a Pivot Table or have an entire column selected?
Thank you for your help.
Never mind. This one was right in the help section. I should have looked
> I have added items to the right-click menu that popups up when you have a
...how to automatically suppress space before after column break?
Having Spacing Before and After on some of the styles, I seem to be unable to
have the space before at the beginning of a column automatically dismissed
when applying a column break. I have tried a couple of options under
compatibility, but to no avail. This in on Word 2003. The No HTML function +
No Space Before after column break do not solve the problem. Can you help
Tools | Options | Compatibility: Suppress Space Before after a hard page or
column break. If this isn't working, then check to make sure you don't have
an empty paragraph before the first text pa...matching columns of numbers
In EXCEL 2000 for Windows, I have two columns of numbers. Column A has
500 numbers, Column B has 1000 numbers. I need to know which cells in
Column A have a match in Column B, and if so, what is the Cell (or row
number) in B that matches to that particular cell in A. How can I do
Thank you for your help.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
try the following:
- insert a new column between A and B (so make B the new C column)
enter the following in B1
=IF(ISNA(MATCH...Categories deleted converting from Quicken
I just converted from Q2003 Premier to the Money 2005 Trial 2 days ago.
I noticed today that a number of categories have been removed from the
transactions in my checking account and credit card accounts. What I've
noticed so far:
1. All sub-accounts for Utilities were gone. This wasn't too bad
because I could use find replace since the payee name has been the same
on these for all years I have in Quicken/Money.
2. All sub-accounts under Insurance were gone.
3. The category Groceries came over, but there were no transactions in
it. Quicken had several hundred...Count the text in a column
I would like to count the text in a column then for it to add a figure in
another cell if it meets the text criteria
Do you mean count the characters?
as an array formula (committed with Ctrl-Shift-Enter)
(remove nothere from the email address if mailing direct)
"Peter Curtis" <PeterCurtis@discussions.microsoft.com> wrote in message
> I would like to count the text in a column then for it to add a figure in
> another cell if it meets the t...Delete contents deletes all data and formulas
When I hit delete contents all data and formulas are deleted. How can I
delete data without deleting formulas?
You could try this
tap F5 - Special - Constants - OK
and if that selects the data you want to delete then tap the delete key
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> When I hit delete contents all data and formulas are deleted. How can I
> delete data without deleting formulas?
First use Find...forms and column lengths
Is there a way to have excel do an auto "carriage return" to the next row
when you have reached the specified maximum number of characters in the row
there's n o bulit-in feature for this
"Blair" <Blair@discussions.microsoft.com> schrieb im Newsbeitrag
> Is there a way to have excel do an auto "carriage return" to the next row
> when you have reached the specified maximum number of characters in the
...Need to retrieve a deleted Excel File
On Saturday I hide an excel sheet and then protected the
workbook. When I got into work today to open the file it
was non-existent. What do I have to do to retrieve the
file? Does it make a difference if the file extension
ended with .csv?
Thanks in advance!
Search in Windows to make sure it's still on your compute
go to the folder the file is in and look to make sure it's still ther
If you didn't do this, you might need to to text, which includes *.cs
Excel is not set to open this type of file by defaul
Did you (try to) open the file with Excel.
If so : did ...Securities with closed positions are being deleted
I am using Money 2006 Deluxe--having upgraded from the 2003 Money Business
It appears that my closed security positions are being deleted automatically
60 days after selling the last shares. Price history for these securities is
I believe that in Money 2003 (Business) that I used a setting that is
causing this (the results, however, were not my intent). Money 2006 does not
appear to have such a setting.
How can I stop this from happening now for securities that I will be selling?
How can I recover the "lost data"
How can I force Money 2006 to pic...Deleted calendar from Public Folders
Accidentally I deleted Calendar in Public Folders on the Exchange 2000. Is
there a way to bring it back?
I tried to locate an article in Knowlege Base searching with "Recovering
deleted items from a public folder", but the article is gone.
On Mon, 3 Apr 2006 21:28:01 -0700, Daniel
>Accidentally I deleted Calendar in Public Folders on the Exchange 2000. Is
>there a way to bring it back?
>I tried to locate an article in Knowlege Base searching with "Recovering
>deleted items from a public folder", but the a...Selecting a column with an integer
' Selecting a column with an integer
' Please show me how to eliminate the use of Cells(1, 1)
Dim r As Integer
Dim c As String
Dim numericcolumn As Integer
Dim alphabetcolumn As String
numericcolumn = 4 ' in practice 4 is the
resultant of an equation
alphabetcolumn = "=CHAR(" & numericcolumn + 64 & ")"
Cells(1, 1) = alphabetcolumn ' I like to eliminate the use of
c = Cells(1, 1).Value ' I like to eliminate the
use of Cells(1, 1)
Cell...deleted items #7
Does anyone know what and how I can view and/or delete the 1129 items my
Outlook says I have in my deleted items folder. 1 says unread.
If can see the Deleted Items folder in the folder list, right-clicking on it reveals "Empty Deleted Items folder"
If you can't see the folder list, it's under the 'Go' menu in Outlook 2003, and under the 'View' menu in earlier versions
You can also empty the Deleted Items folder automatically every time you close Outlook.
Tools menu > Options > 'Other' tab. Choose the 'Empty the Deleted Items f...Calendaring agent failed in message delete notification
We have a user who previously synchronised his calendar with a psion and has
many messages that had reminders on that he now can't delete using Outlook
(gets error) but he keeps on being reminded that they are late.
The psion has been thrown away so how can I delete these messages?
Assuming we back up his calendar can we reinitialise it? Would a mailbox
Event Type: Error
Event Source: EXCDO
Event Category: General
Event ID: 8200
Calendaring agent failed in message delete notification with err...BP Req Mgmt Lookup should show additional columns
When doing a lookup I should be able to configure the columns that I would
like to see visible on the lookup. For example, when looking up an item only
item number and item description are visible fields. I would like to
configure the lookup to show additional fields, like the vendor name.
...Prevent copy and paste in one column
I am having trouble trying to prevent copying and pasting in one specific
column. The code refers to the specific range, but yet it prevents copying
and pasting on the whole worksheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Columns("H:H")) Is Nothing Then
Application.CellDragAndDrop = False
Application.CutCopyMode = False
Application.CellDragAndDrop = True
Works for me in Excel 2003
Gord Dibben MS Excel MVP
On Fri, 30 Apr 2010 11:42:01...copying column width in tables
I created a table in Publisher with 6 columns. I would columns #1, 2,
4 and 5 to have the same width and columns 3 and 6 to have a different
width. I'd like to set the width of column 1 and then paste that size
to the other four so they all have exactly the same width. Presently,
I am eyeballing it, but it takes too much time and is not exact. Any
ideas on how to do this?
The only way is to create guides. Arrange, ruler guides. You could try creating
a table in Word, copy/paste.
Mary Sauer MSFT MVP
news://msnews.microsof...Deletion settings in Mailbox Store Properties
Our company would like to enforce a policy to permanently delete items
30 days or older from each mailboxes Deleted items folder.
The mailboxes all reside on the Exchange 2003 server.
Under Mailbox Store Properties, Deletion settings, the Keep deleted items
for (days) is set to 30, yet the items are not being deleted.
My thoughts are that it is because we do not have the Mailbox Manager
Is that correct?
I am a little hesitant to run it because I am worried about what else it
I only see one recipient policy and that is for email addresses.
I did something bad and enabled EFS on a folder, then decided to
remove EFS. Windows has now left me with a number of EFS*.tmp files
which I cannot now delete and they are really large.
I understand what these files are, but really want to delete them and
so far I haven't found a way to do this, have tried using Admin
privilages and a Google search was fruitless.
"David" <amharcAE@ice.age.fastmail.fm> wrote in message
> I did something bad and enabled EFS on a ...