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...cannot create profiles in win 7 mail 32 bit
I upgraded to WIndows 7 professional 64 bit and still cannot get my MS Office
2003 to work properly. All the programs except Outlook seems to work fine.
I am totally unable to open outlook without mail profiles. I click on mail
in control panel and I get low memoery or resources too low. That's
impossible. I have 4GB RAM and 1GB VRAM.
In addition, I noticed to night that while I created a profile for myself as
Admin, I do ot have admin permissions EVEN IF I say 'run as admin" If I open
my profile, it syas Admin under my name yet shows up as standard user. I...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...change horizontal header position in excel
Anyone know how to change the horizontal position of the HEADER or FOOTER in
EXCEL???? I would greatly appreciate any help. Thank you for your time.
> Anyone know how to change the horizontal position of the HEADER o
> FOOTER in
> EXCEL???? I would greatly appreciate any help. Thank you for your time.
Can't you go into View/Header-Footer and use the "Left-Center-Right"
catagories? You could use spaces in front of your data to move back an
Piranha's Profi...IE 7 and OWA to Exchange 2003
I installed the patch that solves the crash problem when sending a new
message through OWA using IE 7. I restarted the machine but it didn't solve
the problem. I still can't send mails.
We're using Exchange 2003 standard with SP2 on Windows 2003 R2.
Any thoughts ?
"Haim Beyhan" <email@example.com> wrote:
>I installed the patch that solves the crash problem when sending a new
>message through OWA using IE 7. I restarted the machine but it didn't solve
>the problem. I still can't send mails.
>We're using Exchange 2003 sta...Array Formula #7
I have an array formula that works correct up to the 20th row. It quit
running on row 20 or it does not pick up any information after row 20.
Any help out ther
pete5761's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2961
View this thread: http://www.excelforum.com/showthread.php?threadid=49427
Rather impossible to tell...
What's the formula, and what cell(s) is it entered into? What type of
data is in any referenced ranges?
In article <pete5761.205n5a_1134773401.141...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...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...Display Report Header/Footer
Can somebody please give me the telephone number of the smartass MS VP who
came up with the bright idea for the Ribbon so that I can call her and have
her tell me how to display the Report Header & Footer in a report?
Obviously, I must be an idiot because I can't figure out how to do it with
this simplied, intuitive, help-ya out m***** fu***** ribbon.
Oh stupid me, its under 'ARRANGE'. How idiotic of me to think that it'd
under 'DESIGN' since I'm 'designing' a report as opposed to 'arrangeing' a
"microsoft"...2003 Outlook email only downloads headers, not the full message
When I attempt to open an email I receive " This is a message header. The
full item has not been downloaded."
At INBOX, ALT CTRL-S >SEND/RECEIVE GROUP>All Accounts>EDIT >displays an
option to display headers only or the entire message including the
attachment. In the grayed out area, I can see that a dot in the display
headers only section. Due to the gray out I cannot chooose the alternate
How can I access the alternate choice?
Which mail account type are you using?
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft O..."could not fetch new headers " ERROR
i get the error " could not fetch new headers in the inbox of IMA
server.The operation was cancelled ", while using my outlook 2000 o
config: smtp/imap thro internet mail a/c option
pl try to provide solutions to it.
the error message pops up say every 5 min whenever outlook is on.
thnks n regards
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
aggiridharan <firstname.lastname@example.org> wrote:
> i get the error " coul...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...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
...Office 2007 on Windows 7
I just purchased a new laptop with Windows 7. I also purchased Office 2007
but I notice that Windows 7 is not shown on the Office package. Can I
install Office 2007 without any propblems?
Answered your first posting.
> I just purchased a new laptop with Windows 7. I also purchased Office 2007
> but I notice that Windows 7 is not shown on the Office package. Can I
> install Office 2007 without any propblems?
...Apply Headers and Footers
Is there a way to apply a header and a footer to each worksheet without
typing it in for each worksheet
Try grouping the sheets.
rightclick on any tab and choose "select all sheets"
then apply your header/footer
then rightclick on any tab and choose "ungroup sheets"
Pa Maher wrote:
> Is there a way to apply a header and a footer to each worksheet without
> typing it in for each worksheet
...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...Outlook 2007 in Windows 7
I've installed Office 2007 in Windows 7.
Then I installed Lotus Notes 8.5
as my default mail client.
After that I opened Outlook 2007 then it prompted
to set Outlook 2007 as the default and I clicked Yes.
But still the HKEY_CLASSES_ROOT\mailto\shell\open\command
value is LotuNotes exe destination.
What is the reason for this.
But if I use <a href="mailto:email@example.com">send mail</a>
tag in my HTML page it opens Outlook 2007 new mail window.
How does the mailto protocol identifies the default mail client and
open the new mail window?
Pls someo...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...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...IEnumUnknown->Next method causes a crash in MFC 7.1 (VS .net 2003)
I have a couple of ActiveX controls inserted in my MFC (MFC 7.1) dialog
along with 2 buttons. I
used "EnumObjects" method on the ole container to enumerate the Embedded ole
I could get to the IUnknown pointers of the ole objects that i inserted in
the dialog. But after
returning IUnknown pointers for the activex controls (i inserted), the
still tries return some uninitialized object and eventually causes a crash.
I used the following piece of code to enumerate the objects in the ole
hr = pOleObj->GetClientSite( &pCl...