| General Excel Questions (view all ...) | Last Post | Replies |
|
| Disabling Tools/Options setting | 22 Mar 2010 00:58 GMT | 2 |
Can anyone help me to find the VBA code to disable the Tools/Options setting.
This to avoid that the user of a model can change the original setting of a
model.
Many Thanks
|
| How set many row heighths = height of another row | 22 Mar 2010 00:32 GMT | 1 |
Is there a nifty way to use paste special to copy a row and then select a
bunch of other rows and set all of these selected row to the same height as
the copied row?
I need to do this for several rows on several sheets and first getting the
|
| Can I flip a symbol? | 22 Mar 2010 00:22 GMT | - |
I'm creating a form using Excel 2003. I want to have 'clip here' with the
dotted line plus the scissor symbol at the beginning and end of the row. How
do I flip the scissor symbol at the end of the row since it faces 'outward'
and not 'inward?'
|
| Can I flip a symbol? | 22 Mar 2010 00:20 GMT | - |
 Signature
Thank you.
|
|
| New Users (view all ...) | Last Post | Replies |
|
| I put in the wrong server name. How do I fix it? | 22 Mar 2010 02:07 GMT | - |
I am trying to send an email of a database but when I set up my account, I
put in the wrong server name. How do I fix it?
|
| sumif | 22 Mar 2010 01:12 GMT | 1 |
I have a formula:
=SUMIF('C:\Users\John\Documents\Miscellaneous
Stuff\[dbl_approved_items.xlsx]dbl_approved_items'!A:A,C401,
'C:\Users\John\Documents\Miscellaneous
|
| Macro? | 21 Mar 2010 21:57 GMT | 3 |
I have a spreadsheet with 25000 rows.
This is what I want to do:
If ColumnJ has the text "To Be Categorized" then I want to delete that
entire row from the spreadsheet.
|
| Any way to get rid of Sheet1 and ThisWorkbook modules in Add-In project? | 21 Mar 2010 21:51 GMT | 3 |
I have a couple of add-in files. In the Project Explorer, they wach
show two modules in addition to the modules I explicitly created:
Sheet1 (Sheet1)
This Workbook
|
|
| 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 Mid Function with Pivot Table Calculated Item | 22 Mar 2010 01:07 GMT | - |
I'm using excel 2007, I have a pivot table and I'm trying to create a
calculated item, the formula for the Calculated item is:
IF(MID('Project Title',7,1)="S", .20, .10)
The Project Title field contains text and if the 7th character of the
|
| How do I copying data from a cell on sheet to a diff cell/sheet | 22 Mar 2010 00:25 GMT | 1 |
It data entry of scores on worksheet one that has to be automatically copied
to worksheet 2. Once I entry the data on wksht 1 want it placed on wksht 2.
I run tournaments, need all of the date on worksheet 1 but only some on
worksheet 2 so I can sort it. When I set up my wksht 2 ...
|
| Freeze the side column/top row & scroll others | 22 Mar 2010 00:22 GMT | - |
what is the function to set (lock in or freeze) the first column and / or top
row
of a spreadsheet, so the words and numbers remain in the same place as you
scroll the other columns and rows.
|
| no respond/answer from formula entry | 22 Mar 2010 00:20 GMT | - |
I,m entering a formula but when I ht enter ther is no answer/total the
formula looks like this:=b2*(b3/(1-b6)):so b2=11,459,713.00 b3=13.40
b6=39.25%
when i inpt ts formula my cell remains blank. I'm entering it just as it is
|
|
| Charting (view all ...) | Last Post | Replies |
|
| 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
|
| Incorporating Text Box in Excel Chart | 22 Mar 2010 01:03 GMT | 2 |
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 | 21 Mar 2010 22:48 GMT | - |
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 ...
|
| bars on chart do not match data points | 21 Mar 2010 11:11 GMT | 2 |
Simple data set yet when I create a bar chart the bars do not match the
actual values in the cells. For some reason, Excel produces a bar that is
less than the actual value. Further, the same values in a cell produce
different bar heights and although the data labels are the ...
|
|
| 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 |
|
| Extracting data from an excel spreadsheet | 22 Mar 2010 01:46 GMT | 2 |
Please can anyone help with me with some VBA Coding for an excel spreadsheet.
I need to extract the year 2010 data from a master file copy it to a new
spreadsheet, and need to keep it linked. They have set up the spreadsheet
with blank rows and also wants to keep the all the ...
|
| Reading from a dat file | 22 Mar 2010 01:01 GMT | - |
Could someon help me try to read a dat file with lines of text of this
format. If you paste this into a text file it show you what im dealing with.
Im not sure how to look for chr(166) and read whats between the chr
Any help would be great!!
|
| Extract data from csv file | 21 Mar 2010 23:53 GMT | 7 |
I was looking through this discussion group, found something close to what I
need, but not being a programmer, I haven't been able to modify it to what I
am attempting to do and I hope someone can help.
The .csv files are split into groups by month (ie: "c:\Jan\file name.csv)". ...
|
| move one cell down | 21 Mar 2010 23:36 GMT | 4 |
Hi, I need to make a macro who can move one cell down from the active cell
and make this cell active. ex: active cell = C1 => new active cell C2.
I hope some of your hard guys can help me with this problem.
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage