how can i force cell navigation in a specific order via the tab key? i have
done this before but it has been a while and i can't remember how i did it.
thanks for helping.
Lock all cells on a sheet (they are by default).
Then unlock the cells you want to be able to automatically navigate to, and
Protect the sheet, unchecking the option permitting users to select Locked
I hope that's what you're looking for.
> how can i force cell navigation in a specific order via the tab key? i have
> done this before but it has been a w...How to print one header over several columns of data
I want to print one title over a span of columns - what is the command?
Format>Cells>Aligment>Horizontal>Center across selection?
Gord Dibben MS Excel MVP
On Thu, 27 May 2010 14:19:00 -0700, column title print <column title
>I want to print one title over a span of columns - what is the command?
...Format only cells containing certain word
Today I was trying to do something - I had a range which contained some
cells containing the text string 'Manufacturer:' (my inverted commas)
and wanted to format only those cells.
Now, I couldn't autofilter, advanced filter or sort because of the sheet
structure, and amending it would have taken as long as manually
formatting the relevant cells. So I was thinking of how to do it. I was
thinking of a conditional format of any cells containing the string. But
non-numerical (or non-formula) conditions don't appear to be possible.
Could anyone tell me if and how it is po...Column width: Font characters?!? not inches?
All I can find on Column Width is that the measurement I see displayed is
how many characters of the current font will fit across the cell. Is this
correct?!? Is there any way to get the column width in inches?
You can in MacXL 2004, but not directly in WinXL.
With WinXL, you can use VBA. For one way, see Ole Erlandson's site:
In article <#N8g#O64EHA.2568@TK2MSFTNGP11.phx.gbl>,
"Ed" <ed_millis@NO_SPAM.yahoo.com> wrote:
> All I can find on Column Width is that the measurement I se...Conditional Formating based on other cell values??
Is there a way to apply formatting to one cell based on the conditions of
another cell? For example, if A1 is equal to 10 then format C1 to red text.
Is there any way to do that. Please let me know either way.
There are instructions here:
With your example, select cell C1, and in the conditional formatting
dialog box, use the formula:
Dan B wrote:
> Is there a way to apply formatting to one cell based on the conditions of
> another cell? For example, if A1 is equal to 10 then format C1 to red text.
--...Date to close file
I'm using the date code below to close the file but just figured that if
the file is renamed this will fail. Is there code that will close the
workbook no matter what the filename to overcome this ?
Dim exdate As Date
exdate = "07/12/2009"
If Date > exdate Then
MsgBox ("Sorry this spreadsheet has expired please use latest
Application.DisplayAlerts = False
Workbooks("Master 09 17.50 VAT.XLS").Close
> I'm using the date code below to close the file but just figured tha...Displaying a cell's value versus it's formula
I have created an amortization schedule. When you click on
a cell the toolbar shows the formula I used instead of the
dollar value. I don't want anyone to know the formula I
used so I want only the value show in the cell. I know you
can click on a cell and F2 and then F9 to calculate the
value, but I don't want to do that to calculate each
individual cell. Is there a faster way to do the whole
schedule at once? Thank you, Kris
If you lock your cell, and protect the workbook, you can hide the formulas and
just see the results.
Select your range to lock
Format|cells|Protect...Count occurrences of dates
Column A is a list of dates with the format 01/01/2000, 30/04/2001 etc.
How would I count the number of occurrences of dates in column A
for the month of say January 2000
How would I count the number of occurrences of dates for the year 2000
Great If you can help.
For January 2000 you could use a formula like
for the whole year
extend the range as necessary but you can't use the whole column
unless you have Excel 2007
Thanks for your re...change yyyy date to yy
Can I change the date "short" format (yyyy) to "shorter" format (yy)?
e.g. 7/7/2005 to 7/7/05
This would be for a range of dates in an existing column, as well as for new
dates to be added.
Select the col of dates
Click Format > Cells > Number tab
Under category, choose Custom
In Type: box, input: m/d/yy
GMT+8, 1� 22' N 103� 45' E
"Linda Hart" <Linda Hart@discussions.microsoft.com> wrote in message
> ...green bullets in cells
What are the green bullet looking items for in the upper
right corner of each of my cells. This appeared when I
opened a workbook in Excel 2002 that was previously
created in Excel 2000.
Its not a cell comment. I wanted to know if this green
bullet whatever it is can be turned off?
I believe if signals potential errors in the cells.
It can be removed. Go to the Tools menu, choose Options, then the Error
Checking tab. There, uncheck the "Enable background error checking" to
disable all error checking.
... looking out acros...How do you match one column's numbers with the 2nd column?
How do you math one column's numbers with the 2nd column?
Like if you had:
... and you wanted it sorted like so
Any idea how to do that?
lnsykalski's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3403
View this thread: http://www.excelforum.com/showthread.php?threadid=53792
Assuming your data are in columns A and B
insert a staging column before column B, with following formu...Embed Date/Time on existing Video File
I am creating a number of video files that have come from IP Cameras.
I need to be able to embed the Date/Time into the file, so that when it
plays, you see the current date/time appearing on the screen. I know the
start time of the file.
I was just wondering if anyone knew how to do this, either directly in VB,
or if there is an ActiveX component around to do this.
This has to be an automated process, rather than by hand.
Not sure if still current but I saw few years (?!) ago DirectShow Editing
Services which was part of DirectX and is now at :
http...how do you delete account
I downloaded my checking information and somehow the balance is wrong. I
need to delete checking account and then redownload checking activity. I
must have done something wrong during the import to Money. I figured out how
to delete one item at a time but that would be to time consuming being 100
transactions to delete.
The general answer for general cases of people not using Money Essential
(MEss) is to go to the Account List, Select the account, and use the
Delete... choice on the r-click menu.
IF Money discovered this account on its own through the downloaded
transaction dat...Pivot table add one column
How can I add one column in pivot table? When I added a column of Average 100,
pivot table created 3 more columns for the first 3 columns( and I don't like
Book Label Price Average
A Hard paper 200 100
B Soft 100 100
C Hard paper 200 100
F Plastic 50 100
K Soft 100 100
L Plastic 50 100
M Hard paper 200 100
K soft 100 100
R Soft 100 100
T Plastic 50 100
My pivot ...Refer to a defined name in a formula
Thanks for reading this!
I've been scouring the archives but I can't find the answer to this one.
Forgive me if it's there somewhere (I'm sure it must be!)
I have numerous names defined for individual cells eg. sepr, octmo etc.
I am trying to create a formula that will allow me to concatenate two cells
eg 'sep' and 'r' and use this to refer to the cell that the name defines.
My formula looks something like
=25.00*sepr and I would like it to be =25.00*(cell with 'sep')&(cell
=25*INDIRE...Julian Date Question (Another)
Thought I had a handle on it, but guess not. This is my code.
Me.JulianExpirationDate = Format(DateAdd("yyyy", 5, Now()), "dd/mm/yyyy")
Me.JulianExpirationDate = Format(Me.JulianExpirationDate, "yy") &
Format(DatePart("y", Me.JulianExpirationDate), "000")
Shouldn't it be "15039"? What is wrong? Am I missing the whole idea of
Julian date. I realize there are many different methods to Julian date
calculation, some of which include time...conditional formatting dates #3
I maintain a "DEMO" spreadsheet that has a return date for the product of
mm/dd/yyyy. I would like to have that highlighted 7 days before the product
is due back. Any help with a formula would be greatly appreciated!! Also, is
there an ability to format so it also emails me a notice?
One Option, there are others- In Format>Conditional Formatting:
Cell Value is Less than or equal to =NOW()-7
Set your cell format specs to how you want the date to display.
> I maintain a "DEMO" sp...Variables and .value
Heres a simple script I've knocked together, largely by trial an error
$IPadd = ([System.Net.Dns]::GetHostAddresses($_) |select $_.ToString)
"Formatted with Write-Host:"
write-host $(" Username:",$usr.value) -foregroundcolor DarkGreen
write-host $(" Computer:",$comp.value) -foregroundcolor red
write-host $(" IP Address:", $IPadd) -foregroundcolor gray
write-host $(" Domain:",$dom.value) -foregroundcolor DarkYellow
w...ListView header columns
I have a silly question, in a list view in report mode with column headers
enabled I am supporting sorting the items in the list view and would like to
show the silly little up and down arrows indicating ascending or decending
but I don't see any property related to having them displayed. Are they a
custom drawn item or am I just missing the obvious?
Ron Hall wrote:
>I have a silly question, in a list view in report mode with column headers
>enabled I am supporting sorting the items in the list view and would like to
>show the silly little up and down arrows indicati...formula does not recognize value
i have a workbook that calculates exp dates. When the date lands on a
saturday or sunday, I want it to bump out to the following monday.
How can I do this?
Message posted from http://www.ExcelForum.com/
Make your formula consider the WEEKDAY result of its own calculation and add
1 ot 2 according to that.
HTH. Best wishes Harald
"Vato Loco >" <<Vato.Loco.firstname.lastname@example.org> skrev i melding
> i have a workbook that calculates exp dates. When the date lands on a
> saturday or sunday, I want it to bump ...Date formatting won't work
I would like to enter dates in a field using dd/mm/yy, however I want it to
display the DAY also ie: ddd dd/mm/yy. I have tried to format the cell in
custom formatting however it displays exactly what I have typed, even though
the formatting indicates it should read the way I want it to.
I have just purchased this copy of Office 2003. Any ideas would be
It is probably because you are entering a date like 31/12/2005 and excel is
trying to read it as mm/dd/yyyy and since there is no month = 31 it converts
the whole thing into text string.
Always enter as say 31 dec 2004, and w...Form with cells and TextBoxes...how to TAB to textboxes?
I have a simple sheet that's being used as a questionnaire form. The sheet
is Protected, only allowing users to select unlocked cells. Users tab from
cell to cell and either type in or select an item from a list
(Data/Validation). I also put in some textboxes but I can't tab into them.
Is there a way to get the tabbing to work?
WindowsXP, Excel 2003
AFAIK, you cannot tab to a textbox. Tabbing only works between cells. Why
would you want to tab to a textbox anyway?
"Toby Erkson" <email@example.com> wrote in message
Operating System: Mac OS X 10.5 (Leopard)
I am working on a translation. <br>
I created parallel columns as per: <br><br>I am cutting and pasting my earlier work into this format. However, my footnotes are not moving over. I tried to insert footnotes in this new version, but that option was not available in the text box. <br><br>How do I get footnotes or endnotes for the text in the text boxes?
You can have either text boxes or footnotes.
Footnotes cannot exist in text boxes because text boxes are not part of the
text, they're graphi...VBA Code to Delete an Email After it is Processed by VBA
The following code is a hybrid from several internet sources. Mostly
from this forum.
I have an application that starts an email thread and assigns a Task
ID like: TID(123) This is the Subject
When an email is received with "TID(###)" somewhere in the subject, a
native rule then copies it to a subfolder under the CurrentFolder
The following code works to copy the email in msg format to its
associated network directory, but the email remains in the
What I am trying to accomplish is to automatically delete the email
after it is pro...addition with a maximum value #2
Nevermind. Figured it out!
djarcadian's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1587
View this thread: http://www.excelforum.com/showthread.php?threadid=31496