Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel sheet: scroll down, but leave first lines visible10 Aug 2007 16:44 GMT4
Have to solve a problem fast:
Excel sheet has in the first 4 lines text that i want to have visible at all
times
( fix on top ) even when i scroll down on the sheet......
Keyboard shortcut won't copy zero text value?10 Aug 2007 16:03 GMT3
I'm using XL2003.  According to the Help file for Keyboard Shortcuts,
Ctrl+" copies the value of the cell above into the active cell.  The
value I'm trying to copy is '0.0 (apostrophe+"0.0", since the sheet is
set to not display zero values, so I use the ' to make the zero value
Excessive memory use10 Aug 2007 14:13 GMT2
I have a problem running Excel 2007 on a laptop with Windows Vista.
Any time  I work with a file of any substantial size, the program
repeatedly freezes  up.  Windows Task Manager shows that Excel is
using all the available CPU, even though I'm not performing any
IF number is grather than 100 color the cell red10 Aug 2007 03:29 GMT2
I did this before but I can't remember how I did it.  I want to have a
column of numbers and if they are greater than a certain value ie: 120
, I want the sell to have the color red.
Any ideas how to do this in Excel 2007?
Exclude Data of Access09 Aug 2007 23:24 GMT3
I'm trying to exclude some data in my access table, but the code
bellow doesn't work. I need that excel to exclude all data in the
table that contains a criteria in two range of excel.
It's the message error: "no value was supplied for an or more
Within Excel09 Aug 2007 23:05 GMT3
Sorry,
What's happening is that I double click on a 2003 Excel file, opens up in
2007. You cannot view the file unless I click on the Microsoft main menu
button. Then it pops up. I mean that it initially doesn't pop up right away,
Import from TXT file with "No record delimiter"09 Aug 2007 23:02 GMT2
I'm trying to import data from a text file into excel.
Each record is 331 characters and there are no record delimiters. The file
ends with a carriage return and line feed (ASCII13 and ASCII 10)
I'm having no luck importing it and only get one record when I manually
How do I get rid of that large "PAGE 1" thing in Excel?09 Aug 2007 21:18 GMT2
I'm trying to delete the large "PAGE 1" background text in an Excel
spreadsheet.
I used the F1 key, and it was useless.
How can I increase my price list by 5%, multiply missing under pas09 Aug 2007 21:14 GMT3
I am trying to increase an existing price list by 5%.  I have entered 1.05 in
an empty cell, copied it, highlighted the cells to be changed, gone into Edit
- Paste Specials but there is not a multiply tab to use only unicode text and
text.  Help!
Wrap Text in Merged Cell - How?09 Aug 2007 20:11 GMT8
Excel 2007
If I merge several (or even 2) cells in a row, I can not get the text to
wrap when I hit enter.  It works, of course, in a single cell.
How can I get the text to wrap in merged cells?  I have checked "Wrap text"
VBA Query that references a reserved word in one of the field names.09 Aug 2007 19:00 GMT1
I am extracting data from Pervasive 9.1 using Excel VBA.  I want to avoid
using "SELECT * FROM TABLE1". Instead, I want to select specific field names.
However, one of the field names is "DESC" which is a reserved word in
Pervasive 9.1.
Cannot view file after double clicking on a file with 200709 Aug 2007 18:37 GMT4
Also, when I load excel, or word. When I click on the main menu button up in
the left corner it doesn't show up.
Excel 2007 Replace and single quotes09 Aug 2007 17:29 GMT5
I have a spreadsheet that got loaded in Excel 2007 so the cells show the
following info, complete with single quotes:
'02'   'test'    'another column'
'07'   'stuff'   'more data'
How to apply the same formula to an entire column09 Aug 2007 16:34 GMT5
I have a sheet that has over 6,000 rows (data transfered from an access table)
I have added a column
In the new column I want the formula to be =A3=B3 which will result in True
or False and in the next row it want it to be =A4=B4 then the next row should
Vlookup FALSE Value in VBA09 Aug 2007 15:22 GMT2
Hi Group,
I'm using a form to enter addresses into a worksheet and have created
a lookup which is fed by another form, "postcode search"
Private Sub CommandButton1_Click()
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.