Sorting by Color in Excel 2000
I want to sort text by color. I have a worksheet with
some rows in black font and some in red. I need to group
the rows in red font together. Is there anyway to sort by
not possible without VBA
"Greg" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I want to sort text by color. I have a worksheet with
> some rows in black font and some in red. I need to group
> the rows in red font together. Is there anyw...How do you combine two columns to one? Help!!!!!!
I have address numbers in column A and street names in column B, I want to
combine all of both columns into one without going through the whole process
for each individual cells. HELP!!!!!!
"sttrumpet" <email@example.com> wrote in message
> I have address numbers in column A and street names in column B, I want to
> combine all of both columns into one without going through the whole
> for each individual cells. HELP!!!!!!
Use the fuction =A1&B1 in cell B1
Drag the function ...Incorrect formatting opening .csv file in Excel
When opening a database generated .csv file with the following data:
Excel opens it incorrectly formatting the text as a scientific number:
1 1.0E-24 1
If I save the file as .txt, and open in excel using the import wizard,
I can specify that the column should be text, and the item code
10E-024 appears correctly. However this is far from ideal, as it
relies on a manual step
and the file cannot be saved as .csv again - otherwise the same fault
happens next time the file it opened.
Is there a way of forcing Excel to open .csv files in raw da...Page Formatting Preferences Seem To Have Changed
Operating System: Mac OS X 10.5 (Leopard)
Using Word 2004 for Mac version 11.5.6 - For example, I cannot make one line align center with Georgia font and then drop a couple of lines and switch to left alignment and Arial font. Whatever change I make, whether what I am seeking to change is highlighted or not, the entire document changes. <br><br>This used to work fine so it seems like a preference must have changed but I can't figure out how to change it back. Really, really appreciate some advice! Thanks!!
You have mistakenly enabled &qu...Excel #21
I have another question for this paper that I'm working on and I can't seem
to find the answer to. I'm a new user for Excel and I know next to nothing
about it. Any help you can give me would be great...
The question is: "If you see a spreadsheet with row AND column headings as
NUMBERS, what is the problem (if any!!)?
Tools > Options > General tab > uncheck R1C1 reference style > OK
> I have another question for this paper that I'm working on and I can't seem
> to find the answer to. I'm a new user for Excel...How do I seperate 1 page into 2 in MS Publisher 2003?
I have created a "Newsletter" for my company in Publisher 2003. It is all 1
page and I would like to seperate it into 2 so that the print break doesnt
happen in the middle of text boxes.
Also how can I convert the "newsletter" into a printer friendly format. Some
people are unable to print it correctly so I would like to send it out as a
more printer friendly format. I did try converting it to a PDF but it was
then 26mb which is too big to email obviously.
Any help or suggestions would be greatly appreciated.
WolfMaster <WolfMaster@discussions.microsoft....Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
Purpose: create classroom roster between one Excel spreadsheet as data
source and another excel sheet.
I know how to use one excel spreadsheet as a data source to merge with
another word document; however, by using this method, I found that the link
between the files keep dropping from time to time, especially when the folder
has been moved around.
I'm thinking of creating the same layout of the Word document in another
Excel spreadsheet and somehow "LINK" the data source and the other
spreadsheet together, but I'm not sure how, or whether thi...Push single contact field data into prepared excel workbook
I am new to macros but ameager to get some formulated to help run my small
I have been trying to find some code which suits my requirement of pushing
signgular fields from a contact into a pre-prepared excel book which is
loaded with the next stage of macro-powered automation.
I recieve enquiries both via email and by phone. I use my blackberry to
save phone enquiries to address book and Anagram for Blackberry to capture
the required contact data from our email enquiry form. Both are then
synchronised with my Outlook contacts.
Either from the point of creation, or through ...Can you move a page from one publication to another?
Is there a way to pick up a page from another publisher document and move it
into the one you are currently creating?
Select all, copy, and paste.
MVP Microsoft [Publisher]
How to ask a question
"Melis" <Melis@discussions.microsoft.com> wrote in message
> Is there a way to pick up a page from another publisher document and move
> into the one you are currently creating?
...Email Activity Page takes time to close
In my application, if the email content in an email activity page is large,
the page takes 15-20 seconds to close.
I think I should dispose objects while closing the page. But I don't know
where to do it?
...Read from Barcode Reader in Excel and Auto hit enter
I am trying to read a barcode off an item, it then goes into it's place in
the excel sheet but I cannot get it to automatically hit enter, I have to
walk back to machine to hit it.
As I recall (12 years ago...) there is a setting on the barcode reader to
add Line Feed
Bernard V Liengme
remove caps from email
"Neo" <Neo@discussions.microsoft.com> wrote in message
>I am trying to read a barcode off an item, it then goes into it's place in
> the excel sheet but I cannot ...Moving between multiple columns quickly
Operating System: Mac OS X 10.5 (Leopard)
I am trying to move across a spreadsheet from one end (column z) back to column A or last cell with data in it without having to tab all the way. on my pc I would use "end" and an arrow key but my mac keyboard does not have an "end" key. How do I do this?
You can use Command + arrow key on the mac.
...Excell 2002 xp
need to enable file sharing so that we can have version
control on a Excel document
Tools, Share Workbook, select (put a check mark into) the option "Allow
changes by more than one user...." Then make choices in the Advanced tab as
"sarosh Tafti" <firstname.lastname@example.org> wrote in message
> need to enable file sharing so that we can have version
> control on a Excel document
...How can I have an initial zero in an Excel cell?
I want to be able to enter times as eg 0845 but no matter what cell format I
use, there is a problem, either that the initial zero is lopped off or that I
am informed there is an error. Is there any way of solving this?
and you will get a four digit display with an initial display with a leading
Note this is not a time function
> I want to be able to enter times as eg 0845 but no matter what cell format I
> use, there is a problem, either that the initial zero is lopped off or...Outlook 2002 Vcard attachment shows as a .msg file-opens but no information
I am receiving forwarded attachments as a Vcard file from
a contact list. It shows up as an envelope on the
attachment and as a .msg file. It opens but there is no
information there other than a name.
Is there a setting in Outlook that is incorrect or is
this something to do with a setting in the Microsoft
Exchange Server Administrative Rules. I have searched
the knowledge base and cannot find any specific answers
Anyone have any feedback on this or the same problem?
...excel causing system to be in low system resource
Hi all. Whenever i open my excel application, i am always prompted low system
resource and have to exit the application. However all my other office
applications like word, access work fine when i open them. I face similar
problems before and i reinstall excel to solve the problem. Is there a better
solution which can solve this problem once and for all? Thks in advance
...Change theme colors in Excel
Working in the Excel 2010 Beta version, but I think it's the same in 2007...
How can I change the theme and/or standard colors? I can find the colors I
want with "more colors" but I have to add to recent colors EACH time I use
Excel. Any way to change default settings for the color palette?
...Copy sheet in Excel
Wonder if anyone of you encounter this problem before? When I try to copy
worksheet in a workbook, the following prompt comes up, indicating name
"A formula or sheet you want to move or copy contains the name 'aaaa', which
already exists on the destination worksheet. Do you want to use this version
of the name?
- To use the name as defined in the destination sheet, click Yes
- To rename the range referred to in the formula or worksheet, click No, and
enter a new name in the Name Conflict dialog box"
When I clicked yes, another prompt comes up indicating ...How can I shrink a flyer to print two to a page?
I am using Microsoft Publisher and I can't seem to get it to print two whole
flyers on one page. I tried using the two page spread option in the view
tab- but this just gets a portion of the center twice? How can I get the
publisher to do this?
CS Flower wrote:
> I am using Microsoft Publisher and I can't seem to get it to print
> two whole flyers on one page. I tried using the two page spread
> option in the view tab- but this just gets a portion of the center
> twice? How can I get the publisher to do this?
What if y...Paste Cells in Column A to Columns B-K
I was wondering if someone can help with writing an Excel Macro or
What I am trying to achieve is the following.
In Column A (A1:A1000) there are values of L0xxxxxx xxxxxx=numbers
What I want to be able to do is move the values from column A to
Columns B-K (10 Columns) 10 values at a time, upto 100 lines.
A B C D E F G H I J
L00001 L00001 L00002 L00003 L00004 .5 .6 .7 .8 .9
Any help would be appreciated.
T...Avoid pasting over hidden rows
I have a quick question in regards to pasting data over a
range with hidden rows. Is it possible to paste data
over a range of cells and avoid pasting data in hidden
rows? Let's say sheet2 has data in range A1:B5 and row 2
is hidden. Let's say I copy range A1:B4 from Sheet1 and
paste on Sheet2 starting in cell A1. I would like the
data to paste over rows 1,3,4 and 5. (skip hidden row 2)
I'm pretty sure the answer is no but I thought I'd ask
anyways since there are some clever folks out there who
might find a way. (Without using VBA)
Thanks in advance.
W...[Excel 2003] problem in files with pivottables after install Office Service Pack 3
System: Windows XP Pro SP2, Office 2003 Professional + Service Pack 3
I have a problem with some xls files after install office service pack
3. With service pack 2 this files normal open. With service pack 3 after
open file displays dialog (my translate from russian) "In workbook ...
have contents which can not be read. Try restore contents of workbook ?
If you trust source of this workbook, press button YES". If I press "No"
- file not opens. If I press "Yes", displays next dialog. This dialog
form content a list of corrections in file. Biggest pa...Clear rows where field contains a negative sign
I have a procedure called that looks for a negative sign (*-*) in the D column
for all records. If it exists, the entire row is deleted. The procedure below
works well for this situation, BUT when there are no records with the negative
sign in the D column it deletes the first record in row 1. The Range somehow is
set for the value in the D column for row 1.
I have been unable to stop this so far.
Does anyone have a way to not delete row one if the filter is not met?
Here is the procedure:
Dim r As Range
ActiveSheet.Columns(&...Prevent functions from changing when new rows are added
I have a worksheet configured as a timesheet, where each row represents a
task performed. For any given day, I track the task(s) performed and the
hours spent on each task, and there are many functions in the worksheet.
The worksheet contains the following columns:
Column A: blank column (not used for anything).
Column B: series of dates (with a blank row in between each date).
Column C: tasks performed, manually entered.
Column D: hours worked on the task.
Column E: hours worked for the week. There's a function in each cell where,
if it's Sunday, a sum of the week's...Last value in column before blank
Hi, My data in one column A:A - Where V100 &V101 are product codes, dates run
down the column and Blank is a blank cell befor each new product code.
Question is how do i return the date value for the last entry (eg before the
blank) for each product code I want to find. Note also the last date entry is
always the max value date. Eg V100 = 2-Sep and V101 =10-Oct.
One formulas play ...
Assume your source data running in A2 down
Put these in B2:D2
In B2: =IF(LEFT(A2)="V",A2,IF(A2=&...