Moving rows #2
In Word2K, I can shift table rows up or down with Alt+Shift+Up/Down Arrow
Is there a similar keyboard shortcut for Excel2K?
The best I can suggest is..........
Highlight the row you want to move.........Right click > Cut > Right click
to highlight the row below where you want the cut row inserted >
Vaya con Dios,
"David" <firstname.lastname@example.org> wrote in message
> In Word2K, I can shift table rows up or down with Alt+Shift+Up/Down Arrow
> Is there a similar keyboard short...Counting Consecutive cells in a row with a value greater than zero
I have 7 cells in a row (D39:J39). Default value of these cells will be
I want a cell to display the count of cells whose value is greater than
zero. How do I do this?
I was looking at DCount - but from the documentation in help that I looked
at, the values tested need to be in a column. - is this correct.
Any example will be appreciated -
Thanks - Sean
"Keith74" <email@example.com> wrote in message
> Hi Sean
&...How row heights are determined in Excel
Is it possible to change the unit of measure of row
heights settings lets say to centimeters or inches? How?
The short answer is no. Row height is measured in points
or pixels. 72 points or 96 pixels per inch. Don't ask
>Is it possible to change the unit of measure of row
>heights settings lets say to centimeters or inches? How?
for a small macro that does it.
This said, you can zoom both a spreadsheet window and a printout, an...An XML question
I would like to produce the following output based on my XML file:
My Album (2005)
Elapsed Time (hh:mm:ss): 00:07:00
Song 1: title1
Length (hh:mm:ss): 00:02:30
Song 2: title2
Length (hh:mm:ss): 00:02:15
Song 3: title3
Length (hh:mm:ss): 00:02:15
<...Totals on Sales Inquiry native windows
We would like to have the totals on the Sales Inquiries:
Transaction by Customer
Transaction by Document
Today we can retrieve this information in separated inquiries and reports,
be we would like to heve a easier way to see this totals...
The same suggest can be applied to Smartlist. If possible, you can create a
tool to sum a field after you make a filter
I created a screen where you can see all sales, separated by day of week,
and week of year, and totals YTD,MTD and WTD, but I am not able to have the
same information grouped by item number, for example.....Custom icons in Enterprise Custom Fields
Is it possible to load up my own .gifs or .jpgs so that the server is able to
make use of them in the custom icons for formulas? I'm assuming that all of
the icons reside in a specific directory on the server, which I would then
Project Server or Project does not accomodate to use your own pictures.
Sorry to say.
Marc Soester [MVP]
"Brian Lukanic" wrote:
> Is it possible to load up my own .gifs or .jpgs so that the server is able to
> make use of them in the custom icons for formulas? I'm assumi...Limiting a drop down list to a value in another field
I have an Access database which lists certain software. There are two
fields; the software company, i.e. Microsoft, and then the name of the
software itself,i.e. Access. I want the name of the software to be limited
by the company name, so the second drop down would not list, say, Adobe
Acrobat. Is there a way to do this?
Many thanks in advance.
>I have an Access database which lists certain software. There are two
>fields; the software company, i.e. Microsoft, and then the name of the
>software itself,i.e. Access. I want the name of the softwa...Attach Rows with Row Data
I am trying to sort by Data/Time in a Column, but if I sort by Date/Time,
Just that changes, the other columns don't change with it.
How can I either LOCK or ATTACH the Rpw data together so when I sort,
Everything changes, not just the Date/Time?
just select the entire data range (all columns) prior to sorting your
"Admiral_Kirk_1" <Admiral_Kirk_1@discussions.microsoft.com> schrieb im
> I am trying to sort by Data/Time in a ...changing row height
Is it possible to change the row height within the same sheet of some rows
without it affecting the other rows?
A fledgling at 64
yes it is. are you having trouble of any kind??
to set a row....on the menu bar>format>row>row height
set the height to what you want. you may have to experiment.
once set to the desired height and you need to set other rows to the same
height, select the other row and hit the f4 key. this is the repeat action
key. the set the height of the select row to the same height as the last row.
if you need to have different heights then you ...is there a Dlookup to get entire record or multiple fields ??
I am using Dlookup to get a records key value then i am using 4 seperate
Dlookups with that key value to do some math in VBA and its killing me. here
are my lookups
InstallID = DLookup("[installID]", "T_installhistory", "TRKID = " &
Me![TRKIDCombo] & " AND RemovalDate = #" & RmvDate & "#")
InstallTSN = Nz(DLookup("[installTSN]", "T_installhistory", "installID = " &
InstallTSO = Nz(DLookup("[InstallTSO]", "T_installhistory", "ins...total cost on report
I have areport with a cost field that I would like to total that collum at
the end of the report. How do I do this ? do I need to create another field
>I have areport with a cost field that I would like to total that collum at
>the end of the report. How do I do this ? do I need to create another field
The usual way is to use a text box with an expression like:
MVP [MS Access]
I'm in design view of the report, where do I insert this expression?
I clicked on page footer to insert thi...Sending a email from inside Excel
What I have done is created a time sheet for a month, and it also gives me
the hours that are worked in a week. Do what I would like to do is when the
week goes over 40 hours send a email, a pop-up or some kind of message that
this person went over thier time. Can this be done?
Regards Ron de Bruin
"Kelly Thompson" <KellyThompson@discussions.microsoft.com> wrote in message
> What I have done is cr...Setting ID# to 1 & Total on bottom of query result
I have 2 separate questions. First how do I set the ID# to 1 for the
first record. I copied my whole database including queries and forms
which were 2009 records and changed the titles to 2010. I did a
"compact and repair" to the 2010 database. But when I start to enter
records for 2010 the ID# is 2550. How can I reset the ID# back to
start at 1?
On many of my queries I have the results be for example 28 Caucation,
43 African American, 65 Hispanic, 4 Asian, 2 Native American. I need
these numbers separate like they are but I would like a total line at
I have several columns in an income sheet. One column has a sum at the
I want to be able to run a simple macro that will copy the last row of
formatted cells, just above the sum total, and insert it as a new row just
above the sum total so another line of data can be input.
But I want the sum total to sum also the newly inserted row. Presently I
can't figure out how to do it.
A B C
1 24 Oct Dollars In $100
2 25 Oct Dollars out $25
3 Total ...League Tables for sports events
I am trying to find a way to "data-sort" in real time. I have a league table
set up for my football team which lists team name, games played, games won,
games drawn, games lost, goals for, goals against, goal difference, and
points awarded total. The table auto-populates with the scores I enter into a
fixtures sheet. All I would like to do is to formulate a way to get the whole
table to "data-sort" in real time, in the following order ...
Sort by points total (descending), then goal difference (descending)
Please could someone help me?
Take a look at...Copying rows from one Excel spreadsheet to another
At my office, we use Excel 2000 (9.0.3821 SR-1). I have a daily spreadsheet
that I maintain and add comments to one of the cells. At the end of the week,
I maintain a weekly spreadsheet in which I copy the rows in which I have
comments to the weekly spreadsheet. Sometimes, it allows me to also copy the
comments, and at other times, it does not, and then I have to re-add them.
Can you come up with a reason and a solution?
What do you mean by "allows me"?
If you do a regular copy as in ctrl + C it will copy everything,
if you only want to copy comments, copy and when pasting do e...tables and numbering
I have created a six column table in Publisher. The items in each column (or
cell) are numbered items using " bullets/numbers". The first three columns
are listing items by number 1,2,3, etc. However in the last three columns
they are acting like they are linked: first column lists 1,2,3, second
column lists 4, third column lists 5.
Second and third columns should begin with listing "1". The formatting
under the bullets/numbering option seems to be formatted correctly. Any
Do a return, then another return, the next column will revert to one...Finding Cells that Total a Value
I need some assistance in solving a problem. I have a spreadsheet with
over five hundred lines of transactions. The sum of these transactions
are creating a balance on the account. Is there any formula/macro that
will help me find the transactions creating the balance? The sum of the
account should be zero. To clarify, if we owe client money, there
would be a transaction setting up that postive balance then a payment
on the account taking it back to zero. There could be multiple
transactions and then one net payment. Or we could be due to receive.
So at the end of the day, th...invisible graphics and tables
I have upgraded my computer to a P4 3Ghz and FX5600 256Mb Graphics Card and
New Matrox Hard Drive.. Since formatting and re-installation of PUBLISHER i
can not see my Tables or Word art and a few graphics only the Fonts are
Visible. The documents print fine everything is there but i can not see them
on the monitor. I made up a new File saved it then re executed it and the
same thing happens.
Have all updates in, changed refresh rates, latest Nvidia driver,
Reinstalled Publisher and updates. PLEASE HELP ME BEFORE IT GOES OUT THE
Why is it that the first thing people wan...jump to row
Hi all, I posted this problem yesterday and was very grateful for the reply
below, however I have carried out the instructions but it does not seem to
work or I do not understand it correctly, any other help would be great. p.s
I am inexperienced at macros so please explain in simple terms.Thank you
again in advance your help on this site is much appreciated.
I have an inventory with 500 rows all with a number i.d Is there a
command by where I can input the i.d (say 450) I wish to view into a cell
(say B1) at the top of the page and the row will be shown even if it is off
the visible p...Access 2007 Change field size setting
I am new to access 2007 and it is considerably deifferent from 2002.
I have a field (column) which should be a catalog number. I want to enter
numbers such as 001-001, 001-002, etc and an error message keeps appearing
that " I have entereted text in a numeric field or a number that is larger
that the field size setting permits"
I have searche dthe property sheet and can not find a field that will allow
me to change the field size, also when I try and change the format from
"general number" to a text it oly gives me numerical options to choose from.
Please help if ...Total Items
Is there a way to get a total number of items that are about to be tendered,
on the POS screen ?
You can customize the status.htm file. Not sure exactly what the variable is
that you want, but I know it cn be done.
"NJS" <NJS@discussions.microsoft.com> wrote in message
> Hi -
> Is there a way to get a total number of items that are about to be
> on the POS screen ?
Send me your email I have already customized this and will forward you.
"Jason&qu...Sharing lead & opportunity tables
Does anyone know which tables store info regarding lead/opportunity that are
being shared to other users?
The lead and opportunity information is stored in the leadbase and
opportunitybase tables. Information regarding the sharing with other users,
is stored in the principalobjectaccess table. The settings in this table are
reflected in the SecurityDescriptor field with every lead and opportunity.
Hope this helps,
> Does anyone know which tables store info regarding lead/oppor...what is the perl table ??? and how i can use this
...Dropdown for Inside Address in letter headers
I am working to create a company letter template. I want each office to be
able to choose their office from a drop down box in the header and have it
update with the full address, phone, fax, etc. for the appropriate office. I
have seen this done before so I know it's possible, but don't seem to be able
to make it work. Any suggestions or guidance would be greatly appreciated.
You might try an AutoTextList field. See
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA