| General Excel Questions (view all ...) | Last Post | Replies |
|
| Can anyone tell me how to do a mail merge from Excel? | 22 Mar 2010 13:10 GMT | 2 |
I have loaded 388 entries and now cannot figure out how to print to labels.
Some have told me I had to copy and export from Word, but I don't understand
how to do that. Help!
|
| encryption | 22 Mar 2010 13:09 GMT | 2 |
Hi,
I remember there're some products for encrypting the VBA codes (Excel
macros). Has anyone ever used that?
--------------------------------------------------------------------------------
|
| how to serial sheets in workbook | 22 Mar 2010 13:01 GMT | - |
hi,
iam having many sheets within same workbook and i wanna have a serial number
for each sheet as a document number - for example:
sheet 1 have a serial no : 001
|
| Syntax for stopping a Do Loop? | 22 Mar 2010 12:58 GMT | - |
I have columns of data and recorded a macro for taking the average of every
seven numerical entries. What syntax do I use to tell the macro to stop
looping when it gets to a blank cell in the column?
|
|
| New Users (view all ...) | Last Post | Replies |
|
| Excel "Mail Merge" | 22 Mar 2010 13:08 GMT | 1 |
I have a spreadsheet which contains all the current projects we are working
on (each project has a single row) with columns displaying information such
as job title, client, date started, price etc.
I then use this spreadsheet to create job sheets using mail merge in word
|
| Formula wanted | 22 Mar 2010 10:16 GMT | 4 |
I have two columns in Excel. In first column A1:A100 i have some integers
and empty cells and in second B1:B100 I have some stings and also some empty
cells. I would like to apply a formula in C1:C100 somehow in a way:
a) to include all stings Bi that the corresponding Ai are ...
|
| Sorting using formula | 22 Mar 2010 09:44 GMT | 9 |
I have the following rows
A B C D E
Bill A 5 1 Bill B 8
Bill B 8 2 Bill A 5
|
| Freeze Bottom Row | 22 Mar 2010 09:14 GMT | 1 |
Is there a way to freeze the bottom row? I have a spreadsheet with 221
rows. In the 222 row I run totals. Can I have row 222 frozen, so that
whereever I'm in the spreadsheet it shows. I have the top row (titles)
frozen.
|
|
| Excel Errors (view all ...) | Last Post | Replies |
|
| how to download SKU111.CAB | 21 Mar 2010 20:30 GMT | - |
error message "cant find SKU111.CAB fo microsoft office student and teacher
edition 2003. have cd, not on it. how to download it?
|
| automating data copy from dynamic invoice to single spreadsheet | 21 Mar 2010 17:23 GMT | - |
Hi - I am a newbie vis-a-vis VBA. I am trying to copy data off of an invoice
(that keeps changing every day) to a single spreadsheet. So far, I have used
the following code:
Sub CopyCells()
|
| "cannot copy and paste" Excel 2007 | 21 Mar 2010 14:42 GMT | 3 |
Running Excel 2007 on Windows XP
I highlight the contents of a cell and copy, but I can't paste to another
cell, or into another document.
What do I need to do to troubleshoot the problem?
|
| Excel 2003 files won't open with 2010 | 20 Mar 2010 20:58 GMT | - |
Hello,
I currently download your 2010 beta and as soon as i double click on an
.xls file it does now open. .xlsx files open fine though.
If i want to open an .xls file i have to open excel manually then press OPEN
|
|
| Worksheet Functions (view all ...) | Last Post | Replies |
|
| Using match but data needs to be split. | 22 Mar 2010 11:14 GMT | 2 |
I have a table - Y axis contains whole numbers (1 - 20) and X axis contains
decimals (0.1 - 0.9). For each there is a corresponding reference that I
want to be able to look up.
For example, if I type 10.5, I want to be able to look up the value held at
|
| Staff Overtime Form | 22 Mar 2010 10:35 GMT | - |
Dear experts,
I've a worksheet recording staffs' overtime status. Each row is for one day.
For example, a staff input start time and end time in cells A2 and B2. The
overtime hours will be shown in C2. D2 is for overtime description. The
|
| Vertical lookup of pictures | 22 Mar 2010 10:24 GMT | 13 |
I am trying to see if there is a way to lookup a picture in one tab and
insert it into another tab all within the same worksheet. I have tried the
embed function, as well as creating a hyperlink to the picture only to find
the VLOOKUP just returns the text of the link. Please ...
|
| Cell Formats & Hiding | 22 Mar 2010 09:18 GMT | 3 |
I have a worksheet I use frequently, where some cells have zero values.
For presentation's sake, I hide rows where the value is zero, and this I do manually.
The zero vales can and do change.
How do I write a macro to hide cells with zero values?
|
|
| Charting (view all ...) | Last Post | Replies |
|
| Incorporating Text Box in Excel Chart | 22 Mar 2010 12:16 GMT | 4 |
I have a chart that has a text box at the top. Every time I change or move
the chart the text box ends up out of place. Is there any way to
"incorporate" text box with the chart so that it keeps its relative position
as the chart changes or moves?
|
| I CAN'T GET MY CHART TO PRINT ON SAME PAGE WITH MY SPREADSHEET | 22 Mar 2010 07:59 GMT | 1 |
I created a spreadsheet in Excel 7. Then I selected data from the
spreadsheet and created a chart in the same worksheet and placed the chart
under the spreadsheet with primary and secondary axis. Of course, the chart
is dynamic and changes as the data in the spreadsheet changes ...
|
| Can't update my chart | 22 Mar 2010 04:26 GMT | - |
6 months ago, in Excel 2007, I started a spreadsheet showing items bought and
their usage by staff (ie. tea, coffee, soap, etc) from Sept 09 through to Feb
10. It's a really simple little chart. Just now, I renamed my Feb document
as "Mar 10", added the new figures, and went to ...
|
| changing the name in the legend | 22 Mar 2010 01:05 GMT | 2 |
I am using Excel 2007 with XP Home.
I am a newbie.
I am looking at the legend on a bar chart.
Without changing my spreadsheet, how do you change the legend name say from
|
|
| Links (view all ...) | Last Post | Replies |
|
| Compatibility | 12 Mar 2010 17:19 GMT | 3 |
Will it be possible to open files created in Excel 2010 64 bit with Excel
2007 ?
 Signature
The sun is shining.
|
| old vintage | 10 Mar 2010 23:49 GMT | - |
vintage erotic
vintage shirt
'vintage photo' (http://www.vintage-map.info)
vintage definition
|
| Link from Word to cell in Excel | 09 Mar 2010 23:49 GMT | 1 |
I am trying to create a link in Word that ends up at a certain cell i
an Excel Spreadsheet. I have done this before, but can not remembe
how! Any help is greatly appreciated
--
|
| picture | 09 Mar 2010 12:07 GMT | - |
pictures
picture
'pictures of cassie' (http://www.pictures-of-food-2010.info)
pictures of
|
|
| Printing (view all ...) | Last Post | Replies |
|
| Print a 2-sided doc in Excel for a 3-ring binder | 05 Mar 2010 22:45 GMT | 1 |
How do I print a 2-sided document in Excel for a 3-ring binder? I have tried
everything I can think of, but the margins on the backside are identical to
the margins on the front and that doesn't work. The right margin on the back
needs to be like the left margin on the front in ...
|
| Print titles grayed out | 19 Feb 2010 16:23 GMT | 4 |
I have a simple excel file that has four columns and about 100 rows of data.
When I go to print the file, I select Print Preview and go to Setup.
According to Print Preview, there are nine pages of information to print. On
the Sheet tab under "Print Titles", both the "Rows to ...
|
| error 1004 | 11 Feb 2010 15:55 GMT | 4 |
i have writte a program in excel.2007
i print a selected sheet with the VBA command:
ActiveWindow.SelectedSheets.PrintOut copies:=1
so far no problem
|
| Print Selected Columns Together | 03 Feb 2010 19:03 GMT | 1 |
I inhereted an Excel 2007 spreadsheet with information in 15 Columns. I need
to print selected columns together. However, when I select multiple columns
and print selection, all the columns print on different pages. Is there a
way to print the multiple columns together on one ...
|
|
| Setup (view all ...) | Last Post | Replies |
|
| Lightest way to Reregister Excel | 19 Mar 2010 13:50 GMT | 1 |
We have around 60 machines that need to have both Excel 2007 and Excel 2003
available... The problem we face is that depending on MS updates, the default
excel can change form day to day with the result that open Excel version on a
double clic will be either Excel 2003 one day or ...
|
| using excel on my other computer | 16 Mar 2010 02:04 GMT | 1 |
I purchased excel 2007 with power point and all. Can I use this on my laptop
also or do I have to buy a separate one for the laptop.
|
| How can I change the default number of decimal places in Excel? | 15 Mar 2010 16:16 GMT | 1 |
I want the default number of decimal places to be three when I create a new
spreadsheet. I'm using Excel 2007. I sent a spreadsheet to a colleague with a
column formatted to 3 decimal places, but is was set to 2 decimal places when
he opened it on his computer.
|
| My arrow keys are reversed | 15 Mar 2010 16:15 GMT | 2 |
I have used Excel for a long time and have never seen this. My arrow keys
have been reversed. Up is down, down is up, left is right and right is left.
Everything else seems normal at this point. This occurred in the middle of
a session for no reaon I can explain.
|
|
| Programming (view all ...) | Last Post | Replies |
|
| Copy and paste rows from one wksht to another based on cell value | 22 Mar 2010 13:09 GMT | 3 |
Good morning
Was wondering if someone had a suggestion for me with regards to this, I
have the following code that is copying rows from Worksheet1 ("Working") and
adding them to another worksheet in the same workbook called "March":
|
| lookup | 22 Mar 2010 13:09 GMT | 1 |
I have done a subtotal so that the spreadsheet (lets call it Sheet1) looks
like so:
Apple Total 6
.
|
| How to code macro to disconnect internet connection? | 22 Mar 2010 13:07 GMT | 10 |
Does anyone have any suggestions on how to code macro to disconnect internet
connect for macro?
I would like to add a code at the end of macro to disconnect internet
connection, does anyone have any suggestions on how to do it in Excel?
|
| Application.SendKeys & Printing | 22 Mar 2010 12:38 GMT | - |
I am having an issue using SendKeys! (I know, I know they are rubbish)
I have a requirement to print to specific trays for a specific worksheet and
I therefore have set up 3 buttons on a sheets:
Labels Only
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage