Microsoft Excel Misc [Archive] - Page 119

K-mean clustering
Help with Graph Axis
How to code it in excel?
logarithmic x-axis with a maximum between 100 and 1000
Conditional Formatting across many cells with a mobile comparison
Print Page Numbers
Why does this formula not work?
Importing TXT file from web
Could excel chart or worksheet be mail merge?
Under Page Setup the page option of Ledger - for Office XP
I forget the code added on my execl report
Entering text in cells
NPV
Ctrl+home not working, it takes me to the beginning of the row
Strange behavior
Hyperlink open with...
how do i round time to the nearest half a minute
How do I show cell A red when cell B less than cell C (Excel)
web query - stops at login to private data
Linked Cells on Separate Worksheets
file size & error checking
Exporting dates to a path
Highlighting fields while in edit mode of formula
how can I set up a custom filter to ignore the last few digits
Adding actual Cells
Subtotal Averages
how can I syncronize excel files on a network?
Release Memory
PV, NPER, PER and FV
Create Dialogue Box
how do i put bullets side by side?
how pdf picture appears when copying and pasting one sheet to anot
how do i eliminate leading 0 in a text cell
Elimintae wierd charecters
?
Unable to change field settings in calculated field in a pivot tab
How do I get MS - Technical Analysis functions
V lookup in separate TABS!
Remove Numeric from a Text String - Help?
Translation/formula.
Hide zero values in a PivotTable report
Display n x n array
Formatting and the "go to" command
Assigning a macro to a command button
Moving Check Boxes
have one cell display text which reflects a number in another cell
How to Stop Explorer from Opening Online Excel Files
Assign a macro to a command button
New Worksheet
calculate the sum of characters in a cell
cant find excel in my office xp (2002)and how to install it?
Hyperlink Macro
Formula doesn't find last entry
hyperlinks no longer working
merged cells don't center over columns to repeat at left
Find and Copy
How do I copy formulas from 1 wrkbk to another w/o absolute refs
CountIF
Automatic Auto Fill
help on UDF code
Using a function
always present input form
Alt+Tab doesn't work to change from excel file to excel file
Recovery of a password-protected excel 2003 file
Titles in column A appear on every page printed help
How to Switch between different work sheets Randomly
Conditional Formula help
I get a comma instead of a decimal why ?
Shade partial cell
Setting up templates with formats
Excel spreadsheets print too small on the page.
RE: msquery
Editing Comments - Excel 2000
Changing Multiple Defined Names At Once?
2006 West Coast Excel / Access User Conference
Refresh the series in the chart...
Excel formula needed
Office 2003 Send To option of mail as attachment
cannot create templates in spreadsheet solutions tab in excel
WHY I CANT FIND THE FILL SERIES OPTIONS IN EXCEL?
Formula structure, maybe not parenthesis, CELL()?
invalid references in formula
adding words
file save error: the file or directory cannot be created
Creating a Default Border Style
Window XP update has caused excel to not operate
comparing two excel documents
how to delete an old workbook from the right column in excel
Can I use Outlook contact information in Excel w/o import or expo.
Check Boxes
Importing a Value from many Excel Files
how can i make a cell unlimited
Checking balance template in MS excel
How can you access Data Analysis Plus for MS Excel?
Macro aid please
consolidating results of multiple scenarios
Filters and totals
Excel 200 crashes
Chart or macro problem
Exam Marksheet - Grading
download existing spreadsheets into another existing spreadsheet
Help with conditional formatting
Negative numbers in brackets
formula
data table based on data table
How to display month only for date format?
How to code it in excel?
Pointer shapes
How do I produce Automatic Quotation Numbers in Excel?
Graphing problem. Please help.
Very confused....
Editing an excel spreadsheet with the new data in colored text?
Cells no longer highlighted in XL2003 edit mode?
COUNTIF criteria
How do I insert a row at the end of a table.
duplicates with a twist
SUMPRODUCT clue needed
Automated printing
What happened to my special paste dialog box?
Saving Sort Criteria
Totaling pre-defined groups?
Referencing Named Ranges using values in a cell
Excel adding blank rows when sorting
Repeated shading of rows??
Sorting
drop boxes, entering input
Sum by variable column
Control End
intersection naming
convert number to its letters ( convert "1" to "One" )
dynamic transpose
complicated validation and pivot
Excell should have more data sorting features
How to calculate this
changing letters to numbers
self-sizing adv.filter criteria range
Attaching PDF files
Page setup doesn't work
How do I combine 2 woksheets into 1?
When excel is opened, Insert, Format, Data options greyed out.
Automatically Filling In Corresponding Data from Another Worksheet
comments
I made drawings in excel, I don't see them but they print fine.
Excel makes an error
The 1st and 2nd rows of my worksheet have disapeared?
pivot table formatting
WEIRD QUESTION
IF "A" is TRUE and "B" is TRUE?
Conditional date array formula
Double quotes when concatenating with CHAR(10)
Links Don't follow with copy
random number generator
How can I use a long URL in a web query?
Sorting
VBE - Possible to have one of five modules in a VB project to be "default"?
Excel Permissions
make it blank!
Macro to be used in any cell
Cell Protection vs. Worksheet Protection
Drop Down List Ignore Blank
I want to multiple workbooks that have the same columns
Excel file access password
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error
Pivot Table - 50th Percentile instead of Average
Drop down box
List of values
Sumif to external file
What does the symbol <> mean in an Excel formula?
Drop down box
FILTER & IMPORT DATA
Edit Data Form?
Function Help
Slow Opening Excel Files
Data Validation
Linking a pdf file from Excel
how to find a closing parenthesis?
change negative sign from end of the number to the begining
Custom Field label
Why does Excel 2000 crash when formatting a cell to Date?
How do I view the header/footer when working on a worksheet
How to save only row changes to a new sheet
DV dropdown font
Concatenate
Creating a chart using selected cells from worksheet
Refresh Data in Excel Spreadsheet
VLookup
list contents all cells
select a range, copy it to a new sheet
How do I get the Excel Find function to keep finding what I want?
Shared Workbook Ability For Users To Enter New Records.
How can I find the 10 lowest numbers in a list?
Percent of
calculate percentage in pivot
In Excel, use a different row for headings (not row 1)
Excel Hyperlinks..how to get rid of them
Importing
Conditionally consolidating lines within a spreadsheet
ribbon changed after reboot
Mouse pointer change
ASAP utilities addin
Selective Autofilter Application
Form Filling
Q Re: Conditional Formatting
How do you get around &T converting to time in header.
how do i show a zero in front of a number ie 0625 in excel
WHAT FUNCTION SHOULD I USE?
Copy formula automatically down when date is entered
date format
Date custom formats
How do I remove text limit on a cell
No. of rows selected from auto filter not visible on toolbar?
disable user running macro from Tools > Macro
Grouping problems
NAMES DEFINED
Is it possible to copy a conditional format formula as paste value
Sort text that is deliminated within a cell
autosave macro excel
Is this code error-bearable
how can I edit/change the font color in an excel formula?
EXCEL ONLINE MULTI ACCESS
multiple conditional formating
What is the formula to add days to a date
How to delete the blank cells/rolls/colunms to reduce file size?
Add number into one cell to remove from another cell.
change date default settings
divide
how do I change graphics from a drop list?
divide
Re-use Excel macro
Empty Date Cell as Zero
Excel formula?????
How do I make a dynamic print range in excel?
how do i align numbers
Which Statistical Analysis Should Be Used
How to sort al list in random order for sampling?
repeating data in other sheets
Auto Calculate
simultaneous subtotals
format all excel worksheets the same orientation, size
Concatenate Function
Does anyone have access to an audit toolbar?
Unable to horizontally mouse scroll in 2007
Copy Paste... arg...
How do you convert decimal degrees to degrees minutes seconds
excel formula - possibly visual basic method
percentage?
conditional formating
Disable Close Button
How can I exit a workbook in Excel without closing the program?
Re: Summary Sheet help with multiple sheets
Excel 2003: Autofilter
'The process cannot access the file because it is in use by anothe
What does Microsoft want me to do?
how can i hide zero results row in a pivot table?
Code Woes
Excel sheets should move while selected cell stays in middle
Looking up information and returning a value
Excel attachment
Validation List
Conditional Formatting of merged cells, borders don't show correct
List Bldg # according to sum of hours and bldg rank....
COMBINATION FORMULA
Column Header Listing for highest value in a row
Want a column of cells to have drop down box of another text file
Changing cell value according to list value
Can you sort worksheets other than manually?
Can a pivot table calculate the difference between two fields
IF function won't post cell values
COMBINATION FORMULA
User has a blank screen when document is open.
Hyperlinks in Excel
Run macro
Excel's filters should give the option to filter duplicate cells.
Copy macro to another workbook
pocket pc excel
Need Help Formatting Pivot Tables
Negative Times Displayed as # # # #
How can I take information in rows and transpose it into columns?
rank
macro restricted to one column
Database (or the like) from Excel Sheet
Merge rows into one based on value
Automatic Refresh
IF function won't post cell value
Can I sort a source file without disturbing the links?
How do I keep count in an Excel spreadsheet?
opening excel 2003 files with excel 2000??
Formula - to accumulate the number of data appear
Starting at cell with string in VBA
ROLLING 12 MONTHS PLEASE HELP ME!!!!!
Excel slow but NOT when connected remotely!!
[pivottables] multiple table selection fields update in one click...
How to restore F2 functions
Combo box drop down & worksheet protection
Redirect source of pivot table
Data from CSV to Excel
I have a doubt!
How to apply same format of referenced cell in Excel
Formatting Parts of Formulas
Populate lists automatically
Cell format with Data Import (date appearing as text)
Printing: how do I amend my print defaults?
How do I capitalize the first letter of multiple cells?
Unique data
Create a drop down/pop-up calendar in excel
Active Cell To Change Formula
highlighting cells
freezed panes and autofilter
How do you force excel to save on close
Losing cell formatting as a result of a mail merge
Data entry too slow even with calc set to manual
macro in toolbar
Cell Formatting
excel 2007 ventana comparar en paralelo
page break doesn't work. Help is no help. Help?
Importing Data
how come microsoft wont let me type? it's telling me is locked
sumproduct
Concatenating %
changing seconds to timecode
countif question
removing dashes changes test into number
batch delete
How do I use a formula in excel to get a percentage discount
Rounding
Freight formula
IF Statement
2 versions of Excel file opens
Automatic Filtering
rounding help
Moving the box
Pie chart built in 2000, now in 2003 but unable to edit 2003-way
if i save 25.00 a month for 40 years at 5% a year whats the total
Sorting data
AutoComplete
Negative and Positive Time
How do I count cells with text but ignore cells with spaces?
Hilite merged cells
How do you make the cursor go to a designated spot after pressing.
How to have row color change based on one cell to 4 colors
Check Boxes
Countif, Multiple criteria
Parsing Cell Contents
Excel converts 9-digit string to sci. not. when saved as csv
Counting number of cells that make up a sum..
More than 3 conditional formats
Updating List selection on the fly
Excel should support the ISO standard date format
2 sources needed for vlookup
when can I get a 2007 event planner?
VBA Copy & Paste
auto fill of formulas
UDF for x^1/3
One footer section in Excel
Msgbox Code Help Please....
Date format textbox
Referencing cell text in a lookup
Merged Cells In Data Base
Skip hidden rows while copying down in excel?
Register.DClick message
VBA Functions
Formula to Replace or eliminate any sheetname(s) in formula string
Excel 2003: Conditional Formatting
Growth Rate
Create comment from cell range
How I can see distict numbers among range of numbers?
How can I embed a document/object in a "cell" in the xl workbook?
Pull matching data
Does simply pressing the cursor keys launch spell check in Excel?
Change links between 2 spreadsheets
Rank & Group Tournament
wildcard in formula vlookup
Print Preview Zoom button inactive
Multiple records per row
How do I prevent hidden rows from unhiding when resizing row ht?
Worksheets that everyone can access
Do Nothing If Meets Criteria
Macro or Formula?
Excel 2003: Protection
Trying to add a drop down list of all worksheets for the user
How do I get rid of an external link which I can't find?
Excel - How to compare two spreadsheets
Cleaning Up Data
sumproduct for month and year
Splitting the contents of a cell
Merging to Lists into one Unique List
can't open template wizard
Turn existng document in Excel into a template
selecting the next cell down
Excel 2003: Print Area
object behind text and gridlines
Looking for Mortgage Calculation Spreadsheet
How do I manage data from access to excel
Excel Time Conversion
VBA Range definition: Code needed
VLOOKUP error in VBA
Need User Instructions Excel03 ms/hs Electronic gradebook templat
Create a formula to calculate when info. was last updated
Excel & Sharepoint
I cannot see some columns and some menu items are grayed out
print preview
Dynamic chart
Calculations in piviot tables
Calculated Members from analysis services
page layout button slow or freezes in excel 2007 b2tr w/ vista rc1
Dynamic chart/graph
making a cell go red when answer in questionnaire is wrong
How do I skip to a letter in an alphabetically sorted list?
Validation Filtering
Retaining Manual Formatting in Pivot Tables
How do I insert a pound sign infront of different values in cells
limit of characters in Excell
merge cells that contain the same data
Help with lookup
Excel Auto Filter
Refresh the Sourcdata of a Excel Chart
Input color and formula color
Resize Data Labels
Formatting cells to display numbers in euro style
Calendar function
Spreadsheet for calculating interest charges
Graph Question
Sorting cells: a list behind the cells do not move with the cell
Filter
Macro Error
employee schedule
Conditions
Inconsistent excel 2007b2 time calculations that span whole days
count
Create an Excel Update for COUNTIF Formula
Macro help please
COUNTIF Formula in Multiple worksheets.
NEWSREADER
How would I create a report from data in a matrix
Printing schedule with auto increment workday date
How do I get a value instead of an error or txt in an Excel cell?
shared workbooks in excel
Drop down lists that reference another workbook
Can Excel describe a function in two variables: y = f(x,z)
excel add-in function not persisting
How to export a Chemdraw rendering from excel to word?
Check box in a cell
Highlight in Excel but do not print out
Lookup Function
Autoformatting?
Excel skills
workbook won't let me insert new worksheet
Importing Ascii file to Excell won't include Null Characters
Forcing scientific notation to a specific power
enter consecutive cells into a formula
EXCEL 2007 B2TR ERROR
Put help/description in formulas (XLA)
Excel 2003: Copying Spreadsheet
freeze font size in excel.
How can I make a simple check mark column?
All Excel Dates show as 2006
Cannot empty the Clipboard
Using data form in large mailing list spreadsheet
How do I change the AUTOMATIC color in Excel for the font?
How do I turn off EULA
Adding to an exsisting formula
data validation - more than one in same cell?
vlookup and IF function
Duplicating Rows Based on Cell Value
Excel Appearance
how do i resize a check box
How to use validation formulas in Combobox
Excel 2003 text disappear
Time calculation assistance need...., maybe....
Ms Query problem
Conditional Array Formula for date
Is there a way to concatenate date and time?
Excel 2003 - Mouse Scrolls Left to Right..
Taking infomation in one sheet and adding it to another sheet
Excel 2003, how do I save without having to say overwrite?
Data Validation help
how to check for ANY text when conditional formatting?
How do I have a cell display the date its row was last updated?
Why would hyperlinks in a spreadsheet change to an invalid path?
how do i copy data from one sheet to another by d clicking a cell
Copy/Text To Columns/Transpose in VBA
Validation Cell Macro
I need a template for an annual calendar with week numbers
Plot zip code data on map
Data Table
print comments using cell contents, not cell#
2 monitors - Excel 97
Pivot table headache
Pivot table grouping excluding weekends
HOW DO YOU TYPE - OR + IN EXCEL WITHOUT CREATING A FORMULA?
How do I increase the size of check in check boxes
Opening files in folders and subfolders
Dynamic Chart Object
Downloading files from an Intranet site to Excel
change text case in excel without using formula like word?
making a fixture list
When "cutting" the CONTENTS of a cell do not cut the BOARDERS!!!
Automatically refresh XML Maps when opening a workbook
english equivalent to German formular <ARBEITSTAG>?
Macro: how to set a print area of varying size?
what formula do i need to calculate a persons age
How to delete a duplicate Excel worksheet within that worksheet?
calendar in Excel 2000
In Excel why does the / key activate the menu bar?
Macro: copying, inserting & autofilling.
update calendars in Excel?
What means Fix in the status bar in excel
Problems with LEFT Function
tabstrip when chart is saved as webpgae
Extracting info to new tables
vlookup- is a must that lookup value should be the leftmost colum?
Saving settings
Database Analysis Question
Auto Numbering
shared workbooks in Excel 2003
Find if range = 0 or ""
How do you select line or columns in "Line-Column on 2 axes" graphs?
how do i create a report from a matrix
is it possible to progresively number multiple copies
Automatically updating a workbook from a different workbook day by
Picture in comment box
XL / Office taskpane won't go away
Conditional fill
transfer a highlighted cell to another worksheet using a formula
How to select series in chart?
Import multiple text files (Macro)
How do you convert a StarOffice file to Excel?
Spreadsheet shows the formula in the cell but doesn't calculate
make column values column headers
When I click inside the Search Results, nothing pops up.
Drop down that returns to the last selection and can be formated.
Whay have my Excel hyperlinks stopped working?
Create a Graph with a Macro
Macro - color tab
Employee Names in Capital Letters
multi pages in work book
SumIf
Protection on excel file
Macro help!
Macro Help Needed: Comparing cell values and deleting rows
Excel - formulas to no longer calculate.
I'm stumped
How can i design a business model using spreadsheet features?
How do I make colors appear correctly when linking excel to pub?
RE: How do I easily link a block of cells in one spreadsheet to anothe
Sorting data
change case
MRP Formulas
Re: More than 3 specifications for conditional formatting in Excel
RE: Copying excel comments
How do I easily link a block of cells in one spreadsheet to anothe
More than 3 specifications for conditional formatting in Excel
Copying excel comments
Vlookup with col index no. array
printing question
font color
Preview hyperlink
connecting dots on a chart
Borders and excel
Borders and excel
Borders and excel
Check All Check Boxes
Compare part of a cell to a column
Getting info from one worksheet into another worksheet
Validate Whole Number Series with Exclusions
Error: "Excel encountered an error and had to remove some formatti
How do keep colors from a table in MS Excel intact when pasting?
Comment Connector format
SHow comments on an advance filter
Extracting names and suffixes
Is there a way to have a excel automatically alphabetize a sheet?
When will there be a more current release than 2003?
Formatting Number - Is there any way I can the actual value instea
How do I validate latitude/longitude in terms of ddmmss
Formatting Date for Sorting
Track changes and document name
Font changes when I writ email addr!
Password Protection
look up last date ordered
Horizontal line ended with arrows in VB help...
How can I extract the first & last name separated by a comma
Conditional Formatting
Save using Macro but test to see if an error appears on spreadshee
hh:mm:ss keeps converting to a date
enter a value and have excel populate a table with that many rows
Formula that checks several criteria before returing the value???
Hide formula result values until all components are entered
Automatic Colour Fills
How I can change colour of row and column which are active ?
Source data for a Chart
Keeping record of clients and job numbers per bill?
Concatenation 2 Texts
Find Text within a cell
locked file
How to use macro to edit data in Excel cells
Missing fonts?
give up, how turn off Office Clipboard
too many arguments in formula. alternative?
a simple question
Cond Format & Proper
Data Validation Drop Down List - Always Show
COUNTIF & Blank Cells
Using someone else's files
Formula dependent on a cell entry
Crtl+Z reassigned by muppet - cannot find to fix
"cannot shift object off sheet".
cross validation
no decimals
How do I change the size of cells independant from the column
REPLACE
When hiding column error messge"Can'nt shift object off sheet"
Calculations using dates -- HELP!
Lock easily breaks.
limit on size of macro for excell97
find last record in macro and delete all after
formatting rupees
checkbook register
pivot table will not refresh
Selection problem with recorder
GOTO with Macros
"If" statement
help with percentage of yes or no's
set printer to 3 hole punch in excel
calendars
Pivot Table Show Top 10 Error
Excel Sort Contents of cells
how to find nos. of each day in certain nos. of days?
vb code for renaming a work sheet with a cell reference
absolute addressing and inserting new cells
Moving workbook to memory stick - hyperlinks fail
multiple worksheet formulas
Merging of cells while in shared workbook
formulas in excel
Concatenating a Text and a Date without losing orginal Date Format
change imperial to metric
How can I change cell color using conditional formatting
Cells are selected but aren't displayed as selected
Excel formula fails to update
display values between two dates
Extended System Info
VBA setting formula for a cell causes "Wrong data type" error
Interest Rate Givien IRR ((please help me to solve it)
Purpose of double negative
=If(Macro)
Formatting Date
Print job
User-Level Sharing
Excel 2007 Beta Version
printing
Two Excel sessions spawned at startup
selecting next empty cell
complex formula
set of numbers, i.e. [1..48]
How can I write a fromula to subtract 1/4 from 1/2 and so on?
Very Long Calculation Times
Validation doesn't work
In an excel cell, I want my numbers indented less than 1 character
calendars
Excel load message Compile error in hidden module AutoExecNew
Delete Entry Based on Selection
How To Beam Excel 2003 file to Windows Mobile Excel 5.0 (pda)
How do I assign a letter value to a range of data?
How do you format data that is part of a drop down menu?
Userform List box to Text Box
Lookup 2 values
save as w/sheet
Personal.xls
Cell format in Excel
How do I create and save .odc and .oqy files in excel?
worksheet menu bar "disappeared" suddenly
Making chart with hidden Data
Need to store changing values from one cell
Spilting Data in the same cell
Multiple criteria/Countif question
If I have date, can excel calculate the day for me?
SHOPPING CART
How to show or hide outlined data option in a protected worksheet?
Saved-workspace weirdness, questions
Conditional SUMPRODUCT
I want to combine 2 workbook data bases and remove duplicates
How do I create a cell reference to return name of the tab?
Number Formating Cells (Time)
Work schedule development question
change an icon
Automatically save a file in another directory
formula question
formula
If a cell contains "preferred" then do this
How do I remove a flash object "stuck on" my spreadsheet?
File in use error message on a non shared workbook
Bond prices convert to decimals
When I select a cell in Excel I cannot deselect it. Ideas?
Charts and formulas
Spreadsheet Linking to Calendar
How do I combine cells? ex. first name, last name columns
Limiting files to a single computer
Pivot Table - hide if no data
Excell page moves horizontal not vertical
restore
AutoFiltering
select next empty cell
when certain number is typed in a cell to display a message
if then date formulas
inventory
'anchoring' or 'grounding' part of a formula
Extra excel windows
linear growth rate graphing calculator
How do I eliminate the green triangle throughout my spreadsheet?
Maximum amount of worksheets in single file
ascii conversion
need a large spreadsheet
Making Percentages
printing labels from rows
How do I quadruple numbers starting with 1, 2?
create
Calendar Holiday question
How import table and have Excel sort automatically?
can you put formulas and labels in the same cell
open the time formula automaticly in B1 after tabbing from A1
all my top rows are now numbers, how to set it back to letters
Importing External Data From Several Files
Paste Word Check Box Form Field Link into Excel
Like the DAYS360, Datev& Time Function is there one for 365 day ?
How would I add a loop for this?
Eliminate anti-rollback in Excel 2000
List
Linear trend function: 5 year increment
Getting data from one excel sheet into poreset tabs?
How do I count 2 columns of data that meet a certain criteria?
Pivot Table
Adding up hours and minutes
"Uncombining" Text
cant save read only file
convert text into Formula
Lotus 123 files
lock folder
Standard font in a "New Microsoft Excel Worksheet.xls" wont change
picture size can not change to web quality
Printer message
Hi Alllen
Excel Query
VLOOKUP NOT WORKING
Windows application error message
How to find values in string? - Urgent!
storing real time data
Find future dates
Cell format
change lower letters to upper letters
Compare data from one column/spreasheet to another?
is there any way to have more than 3 conditional formats per cell