|
|
Macro to find a JPEG & insert by
Larry
I have a worksheet ("Winners Log") which has a list of JPEG numbers in column
A. I want to click on any JPEG number, have Excel find that JPEG photo in
the...
|
|
5 |
441 |
|
|
|
|
3 |
441 |
|
|
Conditional Formatting & Blank Cells by
Dominique Feteau
I have a large sheet with about 1000 rows and 9 columns. I want each blank
cell to be filled with a color i specify (lets say yellow). How can I do
this with...
|
|
5 |
441 |
|
|
cell numbers in sequence by
karen
I'm trying to format my spreadsheets so that when I'm working with numbered lists, the numbers stay in sequence. If I delete or add rows or if I type a number...
|
|
2 |
441 |
|
|
Duplicate Rows by
Dtruelove
How do I filter rows with duplicate information? I've downloaded a spreadsheet containing about 7,000 rows. Some of those rows contain duplicate data. I...
|
|
2 |
441 |
|
|
|
|
1 |
441 |
|
|
loosing formula from excel to pocket excel by
jason bates
when i transfer an excel file that contains =convert
formula when used on a pocket pc the formula is stripped
away - why is this ? is there an add in for the...
|
|
1 |
440 |
|
|
Merged Cells / Wrapped Text by
Robert Johnson
When I have a large amount of data being fed into merged
cells, wrapped text dissappears after roughtly
1000characters. Is there a way to change this? As...
|
|
1 |
440 |
|
|
dotted decimal ip addresses in excel by
Jason
I have a cell that contains a typical IP address in the
form 123.456.789.012 (dotted decimal).
I want to break each octect into a seperate cell, so that
if...
|
March 25th, 2004 12:01 AM
by Jay
|
2 |
440 |
|
|
|
|
7 |
440 |
|
|
Copy and paste between workbooks by
rky
Hi , I am trying to copy an entire spreadsheet from one
workbook to another workbook. But it only copies the
values not the formulas and if I try the paste...
|
April 29th, 2004 07:26 PM
by rky
|
0 |
440 |
|
|
VLookup Function by
Greg
When using the VLookup function, I am using "FALSE" as the
argument, for the "range_lookup" argument, because I only
want an exact match; however, it returns...
|
March 16th, 2004 07:00 PM
by Greg
|
2 |
440 |
|
|
Funcs work differently as array formula? by
Jonathan Rynd
While doing some auditing I noticed that the IF() worksheet function
behaves differently when it is entered as part of an array formula
(control-shift-enter)...
|
|
3 |
440 |
|
|
|
September 18th, 2003 01:34 AM
by acw
|
1 |
440 |
|
|
Removing password protect workbook option by
Brian
I password protected a large, multi-tab workbook so that shared users would not alter the structure. Even though I have a long history of well-documented...
|
|
1 |
439 |
|
|
INDIRECT formula question by
wardcanoe
I have used the INDIRECT formula many times on a
particular spreadsheet. ie
B1: D
A1=2 C1= INDIRECT(B1&A1)
A2=2 C2= INDIRECT(B1&A2)
A3=3 C3=...
|
|
2 |
439 |
|
|
|
|
0 |
439 |
|
|
|
December 2nd, 2003 09:43 PM
by Jim
|
5 |
439 |
|
|
convert numbers to text by
bMunny
Hi Everyone
I import a column of numbers from a database to Excel.
The column comes in as numbers. I need to convert these
to text but it's not exactly...
|
|
6 |
439 |
|
|
Check Boxes And Macro HELP by
Johnathon
hi,
i have a spreadsheet with about 4 columns of data. while
recording a macro i deleted every cell in the 4 columns
of data. i then had a button and i assined...
|
|
1 |
439 |