Undo skips a step
You would think that by now, after over 20 years of computing, I would know
how Undo works, but Outlook has me flummoxed. While cleaning up my inbox and
deleting entries, if I change my mind and issue the Undo command, about 75%
of the time, Outlook does not restore the most recently deleted item, but
one from several deletions past.
What causes this??
...Copying a formula but 'skipping' a cell
I have a spreadsheet with 2 workbooks. One is an automatic data input from a
GPS logger which provides a CSV file that imports a comma delimited format
into discrete lines.
The input comes in from this worksheet (import) as
Data Set A1
Data Set B1
Data Set A2
Data Set B2
The main worksheet (main) needs to display these as
Data Set A1 Data Set B1
Data Set A2 Data Set B2
I've done a sample for 10 data sets (e.g. first bit of A1 is =import!C14)
but I need 1000 lines in the main worksheet. Problem is that when I copy and
paste the formula it increments the cell reference by 1 and I ne...Skipping Columns/Rows
Is it possible to skip a column or row when tabbing in a workbook? In
other words, when I'm in A1 and I hit the tab key, I want to be in C1.
P.S. -- I do not want to hide the columns as I'm an advocate of using the
least amount of steps as necessary to produce a document. In other words,
I do not want to hide, enter data, unhide, print, receive additional data,
hide, enter data, unhide, print, and so on and so on.
Format columns A and C to be unlocked (on the protection tab of the format dialog).
Then protect the sheet, and allow selection of unlocked cells on...How to skip the confirmation on updating link?
for updating links, under Edit > Links, I have specify that
Excel always update links, and save it, when I open it next time, message
box is still pop up for confirmation.
Do you have any suggestions on how to skip the confirmation on updating links?
Thanks in advance for any suggestions
What version of Excel are you using? In 2003 the option you want is Edit,
Links, Startup Prompt, Don't display the alert and update links.
If this helps, please click the Yes button.
> for updating links, under Edi...skipping rows with zero values
Here's my problem - Want to be able to skip rows with zero values and place next non-zero row in the one skipped.
many thanks jojo
Try using Autofilter, filter column B for 0 values, and
then delete those rows.
>Here's my problem - Want to be able to skip rows with
zero values and place next non-zero row in the one
>many thanks jojo
I would probably s...Skipping Zero values for plots
How do I make a chart such that if I have some zero values then those
dont get plotted (especially in case of Line charts). Rather if I have
Then I would have only a straight line from Oct to Dec. I might have
such zero value pattern for many data points.
Is this possible to achieve without any complicated manipulation (I
think I have one in mind).
1) replace 0 (or blank) by =NA() which displays as #N?A
2) delete 0 in data; click chart; use Tools | Options and open Chart tab;
specify how missing data is to be treated
bes...repeat a formula, skipping cells
Microsoft excel. Is it possible to quickly repeat, or copy, a formula down a
column skipping the same number of rows with each copy. e.g. give the total
of a1..a4 in b4 and copy this so that you get a5..a8 in b8, a9..a12 in b12,
Select B1:B4 (b1:b3 = empty and in B4 =SUM(A1:A4))
And copy the four cells down
Regards Ron de Bruin
"Hucleberry Hound" <Hucleberry Hound@discussions.microsoft.com> wrote in message
> Microsoft excel. Is it possible to quickly repeat, or copy, a f...Skipping Sales Stage
I am hoping to make a workflow for an opportunity that will wait for a drop
down in a custom field on the opportunity record to be "yes" and then skip 1
sales stage (or change that sales stage to prospect which is the second one.
I am afraid thats not possible. But you can workaround if you have too.
The workaround i am think of is that you will need to break the sales
process into multiple sales process.
For example you have one sales process with 3 stages. and on the condition
you have you want to jump to the 3rd stage from the 1st.
The wa...Conditional skipping fields
I'm trying to code a data entry form where the user selects an option from a
drop down list and depending on the value the cursor moves to the area
pertaining to this.
e.g. Choosing from animal, vegetable or mineral.
If mineral is selected then the cursor bypasses the animal or vegetable data
entry options and goes to the mineral choices area and proceeds.
I hope this explanation is adequate.
Sub forms in this instance may be a little messy for the operator.
Sounds suspicously like a Spreadsheet converted to Access
You Should split into (at least) three tables animal, vegetabl...numbering rows, but skipping blanks
I'm using Column A of a spreadsheet to number some items in Column B.
I've been using Excel's automatic series-filling function, where you
drag down from the lower right corner of a cell. However, since some
of the rows in Column B are empty, and I don't want them numbered, I
have to stop numbering and manually "jump" over the blanks in Column
A. Is there a way to automatically number down in Column A, while
skipping over the blanks and continuing where I left off? I.e.
? Thanks much.
Try this in A1:
I want to calculate the settlement date(SD) base on the trade date (TD).
Normanly the SD is TD +3 business days. (Skip weekends and holidays)
I set up this calculation:
This works fine until there is a holiday ( eg. 7/4 and Thanksgiving) in the
See the NETWORKDAYS function. It will do exactly what you want.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"any" <email@example.com> wrote in mess...skipping data for a chart
Is it possible to make a chart from a spreadsheet and not use some of the
cells, i.e. data? Can you pick a range of data from cells that are not
"Glenn Vatter" wrote:
> Is it possible to make a chart from a spreadsheet and not use some of the
> cells, i.e. data? Can you pick a range of data from cells that are not
"bj" <firstname.lastname@example.org> wrote in message
> "Glenn Vatter" wrote:
>> Is it ..."Last Channel" center button skips first number on new STB. MCE 2005 XP
The new STBs that I have use exactly the same IR commands as the ones I had
before. Changing channels or going up or down is not a problem. But when
I hit the center button to "return to last channel viewed" it SKIPS the
first number. There must be a setting in the Regestry for this, can anyone
...Sort data and have it skip everyother row when it is sorted
How can I sort my data in a column and have it a blank row between every entry
First, I'd just increase the row height so that it looks like the rows are
double spaced. (Inserting empty rows can screw up other things--pivottables,
But if you want...
Sort the data the way you want (we'll add the blank rows later)
Find an empty column
put 1 in the first row (with data) in that column
Put 2 right under it.
Now select those two cells and drag down the length of your data.
You'll see a nice sequence of numbers--1 through the number of rows you need.
Select tha...Skipping every other data element when charting
When I am charting it is skipping every other data element/row. So for
example if I have sally with 40% and then Joe with 70% and then Mary with 80%
it only lists Sally and Mary on the chart but shows the bar for Joe, just
doesn't list his name under the bar. Why is that?
Double click the category axis and on the scale tab make sure the
setting of 'Number of Categories between tick mark labels' is 1.
> When I am charting it is skipping every other data element/row. So for
> example if I have sally with 40% and then Joe with 70% and th...Bubble
When I make a bubble chart, xls skips the unpair data ??
It takes only the 2nd - 4th - 6th - ... values.
Any idea what I do wrong ?
On Mon, 5 Nov 2007, in microsoft.public.excel.charting,
Gecko <Gecko@discussions.microsoft.com> said:
>When I make a bubble chart, xls skips the unpair data ??
"Unpair"? Do you mean "odd" as opposed to "even"?
>It takes only the 2nd - 4th - 6th - ... values.
It takes the 1st value as bubble X value (for all series), and the 2nd,
4th, and 6th values as bubble Y values. It is taking the 3rd, 5th, ...DiscoverCard (DC) skips transactions
I see several different sounding DC problems so I am starting this one
for my specific problem: Mny03 Dlx - DC Update skips transactions.
My theory is that it is a DC problem related to out of date sequence
transactions. By this I mean a post dated transaction, eg a new
transaction with a date older than current transactions.
The CD site does not support manual download of .qif files so one must
manually add the missing transactions.
I think this is a new problem.
I have the same problem. It started about April 20th and
since May 7th it didn't import a single transacti...Skip Records in a Form
I have a form in my database based on a table. The table is appended with
new reocrds everyday. My goal is to have the form present only the new
records and allow a user to key data into the new record and be recorded in
the same table. The issue I have is that the form is displaying all records
not just the new. Does anyone know a way to open a form and display only
those records that have not been updated by the user? Thanks in advance
Add a column for UpdateDate and update this column whenever a record is
updated via the form.
Set up a query to read all the rows/columns ...outlook 2003 send sometimes skips recipients
I am supporting IT at my company.
We have seen a problem with employees running outlook
2003 with exchange 2003.
When employees send email to a distribution group with
say numerous members bet 3 and 20 recipients all on our
email server sometimes the email does not go through to
This happens when sending/forwarding email or new
All our Outlook clients and exchange server are running
the latest service packs.
Has anyone seen this problem?
...Pressing Enter to skip rows
We have a pro-forma in Excel for clients. Anyway, the cells where the
enter information from a drop-down list are three rows apart, goin
down the page.
Is there anyway for the client to press Enter just once and go thre
rows down rather than pressing enter three times?
I am aware that if the sheet is locked with the particular input cell
unlocked then Tab will take you to the next box however, we need Ente
to do the same.
I imagine a macro could achieve this.
Thanks in advance
Is there a way to skip a field when a yes/no box is checked?
If a YES is in field A, I want to next go to field D and continue my tab
order from there. If field A is not YES, then you go to field B.
"DonElston" <DonElston@discussions.microsoft.com> wrote in message
> Is there a way to skip a field when a yes/no box is checked?
> If a YES is in field A, I want to next go to field D and continue my tab
> order from there. If field A is not YES, then you go to field B.
> Thanks...stop cursor skipping to different place in text while typing
My cursor just skips to a different place in the text while I type. So I end
up with what ever I want to write but in the middle of a previous sentence or
paragraph. This is very annoying. Does anyone know how to turn this off?
"Woo" <Woo@discussions.microsoft.com> wrote in message
> My cursor just skips to a different place in the text while I type. So I
> up with what ever I want to write but in the middle of a previous sentence
> paragraph. This is very annoying. Does anyo...Summing across columns while skipping some columns
Does anyone know of an easy way to accomplish this?
In the example below, I do not wish to add the values in columns G18 and J18.
Thanks in advance for any replies.
Note the third argument is not needed since you are summing the same range
as you are testing.
Microsoft Excel MVP
email address: remove uppercase characters
"JAG" <JA...Win7 backup error: Windows Backup skipped I:\ because it cannot be found on drive I:\
After expanding my O/S disk and thus deleting "Disk I" my windows 7 backup
completes successfully but gives me the above error for the previously
deleted Disk. More of an annoyance. I DID have a disk I on the first Backup
file I did before the expansion and I have NOT tried to restore any files,
etc yet. I am looking for a registry or ? change that can fix this and not
necessarily a 'work-around.' My Computer, Device Manager, Win 7 Backup
devices, etc do NOT show any "Disk I." available on the computer. All help
Backup error: Window...Skip condition if cell is blank
I have 4 conditions
1) If Sheets("Details").Range("H" & lngRow) > Date - 90 And _
2) Sheets("Details").Range("F" & lngRow) = Sheets("Search").Range("C2") And _
3) Sheets("Details").Range("J" & lngRow) = Sheets("Search").Range("C4") And _
4) Sheets("Details").Range("I" & lngRow) = Sheets("Search").Range("E4") Then
if Sheets("Search").Range("E2") is blank then condition 1 should be skipped