Microsoft Excel Misc [Archive] - Page 159

Move cursor through all unprotected cells in a protected worksheet
Locating saved Excel file
copy file names
Formatting merged cells to have lines.
Qube Root?
Using if or sum if to change range of sums
HOW TO EXTRACT STRINGS FROM CELLS
Pivot Table
Table array
web query doesn't work
Footnotes
CANNOT OPEN EXCEL FILES
how do i recover a forgotten excel password
simple question
Aldersberegning
use of folder management
Pivot Table Chart
Pivot Table Linking
Printing
Missing format and symbols
Download from the Internet into Excel
how to undo a saved file
sum between workbooks
Automatic Histogram with Inputs
listing all names in a worksheet
how do i square all items in a colums w/out doinf it one-by-one?
Inflation Adjustment
how do i list the names of all my worksheets
Which Function do I use
translate number in dollars to wording in excel 2003
msg: "No more new fonts may be applied in this workbook"
Custom number format button
How to ignore parens in a sort?
Clear Cells
Forcing users to complete a form
Jumping columns
self-updating formula
How do I use long date format in a header or footer?
Excel - Auto Hyperlinks - Errors
Can't manipulate pivot table
For accounting, How to link two lists each in different drop down
Worksheet Links
Sort by Hebrew Date
Force values-only when pasting text to keep formatting
How to put hard returns in a cell without going to the next cell
Incrementing numbers for every page printed
Excel-update spreadsheet, keeping integrity
Recalculating a very large spreadsheet
Ask user for input during marco
Get row values into column
option to insert column and row breaks
How do I get rid of task pane permanently?
Double Stacked Columns - can it be done?
How do I convert from text to columns automatically on import?
How do I get Excel to recognise dates prior to 1/1/1900 ?
I want the greater number of 2 cells to show in a separate cell
Right Click Pivot table -> Wizard -> Back button is disable
Hyperlink to open .dot with a macro
Add one Month in the next cell for several months/years
How do you prevent duplicate entries in an excel spreadsheet?
RE: I want the greater number of 2 cells to show in a separate cel
how do I insert a row without the formula changing?
allow text over a non-blank cell in Excel
how to insert page numbering in an excel cell
How do i make every first letter caps?
How do I create a "floating" header in Excel so I can always see i
Filters in Excel
Want to use key words to locate essays
want to find two matching answers governed by two separate equatio
How do I append data in several cells in one column
Create and Use Button Menu using visual Basic in Excel
Convert Text Entry to Date Format
templates
hyphenated number format with leading zeros to the right of the hy
Remove double data entries
how do i show text in the data field of a pivot table?
pda files to excel
MERGE 2 FILES
Excel 2003-paste
RE: How do I get rid of task pane permanently?
Using Multilpe Lists in Excel 2000
Consumption function
RE: I want the greater number of 2 cells to show in a separate cell
match whole word only
consecutive numbering
Option to print worksheets in the same page
Use wildcards
Web Options?
I can't open an xls.file compressed(zipped)folder in Windows XP?
VLOOKUP
can't open file by double click
Fixed Decimal Question
Forecasting
Template opens blank
Binocular search tool, Excel, loses column designation at "Find"
how do you get Word to open documents in it's own window(s)?
FLOATING CELLS HELP!!!
Sorting of data in excel 2003
how do I make the cursor appear as a coloured outline box?
Scheduling a Task to run Excel
Here's a challenging question for you...
Help write Macro
Taskbar group buttons unchecked and Excel
Link cell
outlok today [ display name ]
CONDITIONAL FORMAT
How to get data
template
comments
Formatting X-Axis in Chart
Autofilter to search characters that begin with "* "
How can you mix text and a hyperlink in the same cell?
Re: compute? hmmm.
Printing formulas
Date format not correct when you convert a CSV text file in Excel
run time error 1004
Copying formulas
Save in Multiple format crashes Excel 2000 SP3!
how to lookup a value within a range and return a label
The operation failed due to network problems
selecting multiple sheet tabs and open another workbook
Data which is over 65536 lines long
Autofilter Function
Problem inserting a new worksheet
When saving CSV excel always prompts about the file format
different page margins when used different printer driver
broken links
Data validation
How do I sum a range of sub-totals?
how do i convert numbers in figures into words?
Randomized Functions
Language default setting not responding accordingly
Interactive checkboxes
How to load Template Wizard /tracking to operate in Excel 2003?
Excel 2003
Conditional Lookup
Deleting Lines in Excel
trial version
Excel Math formulas
vlookup still gives na
Lookings for optimal coefficient
how do you lock a jpg on a spreadsheet that you publish to web?
Footnote
Formulas in Worksheets
crazy mouse?
Can anyone suggest a good scheduling template for weekly shifts?
How to find/replace data in column
past rows into columns
HOW TO PUT MORE THAN ONE WORKBOOK ATTACHMENT IN AN EMAIL?
Vlookup: Have problem. Not taking the object that i search...
activex controls, no "Control tab"
Return to the last accessed cell in a multiple paged file at reent
Extremely complex problem: showing a value as an 'axis' on a circle
counting cells with two criteria
Worksheet Names (Revised)
please help...anybody!
Help with complex VLOOKUP
Show a grid pattern not corresponding to the cell sizes
Hyperlinks
split column into 4 columns
brainteaser: change a value by 90 (but answer must lie between 0-180 )
Duplicates
How do you change the sign (e.g. +3 to -3 OR -3 to +3)
Pivot Table Question
Conditional formatting based on decision to enable/disable macros?
Active cell moves off the screen
Deleting Cells Option doesn't appear
adding vertical bars to an embedded chart using VBA
Find a date in a list
Charts: want to assign fixed color for each slice
Remove Box or Squre Characte from Cells
R1C1 reference style
How do I change the display options in the status bar of MS Excel
concatenate cells from a column and paste to a cell
How do I change format of page numbers to letters in Excel?
if then statement in VB
Worksheet Names
Excel File sizes and speed
Password protect Excel and Word FOLDERS (not just files)
Delete word from multiple cells
customizing pivot tables
How do I delete hidden character in Excel?
Entering Times
Custom View Bug?
Really appreciate some help on merging two spreadsheets...
Tab key problems
Customized Task Views Have Disappeared (Take 2)
export find results
Date Calculation
headers and footers
Remove Data Format Change
:S confused :S
excel spreadsheet is 4.77mb but only has 126 rows, why?
Help needed with this formula
Make it look "nicer"
Automatically update a 2 lists
How do i change the heading of excel columns to alphabetical
Define Name option missing??
Hyperlink problem to cell in same workbook
sumif
Calculation using rolling 4 week amounts
How can you add a picture as a backround?
Pack data columns into one serie only
Pivot Table Freezes
How do I freeze a pane on Excel but leave one line unfrozen?
Excel Language worksheet
EXCEL FORMULA
addin workbook
Excel 2003, Convert EXISTING Worksheet Data to XML?
need help reformatting spreadsheet
Common Private Sub
I need formula that will automatically count the filled cells.
two-variable calculations
Excel
MSNStockQuote AddIn for Excel should include a "YIELD" option.
formula for custom output
How can I customize Freeze Panes in Excel?
Links to other workbook
Tab color in Excel 2003
Backup
Macro to include contents of cell
copy formulas by dragging vertically
Excel says macro, but no macros present?
illegal operation when doing page setup in Office 97 Excel
pivot table - New Data
freeze the worksheet panes
Transposing data
How do I change the format in a excel drop box?
formula help
ListObject in Excel 2000 ?
Small Business Financial Manager
Sorting Issue. Please help
how do I turn off requesting scan when opening Excel (Office XP)
Sort mixed numbers/letters
How do I change headings for columns from numbers to letters?
Macro to update sheet
phone number dilemma
Formula TIME question
Vlookup using 2 conditions
Pivot cache
Excel 2000
Worksheet Tab Font
center across selection formatting
macro to sort data in worksheet by specific date
format inplied decimal point
Exporting addresses from excel to outlook
Excel Capital Letters
How do I change row text colors in Excel based on formula?
Exporting addresses from excel 2003 to outlook 2003
Using macro for decimal decrease or a utility ?
SUM for logical values
curve fitting a charging capacitor type curve
Heading
any tips on working with feet and inches in excel?
Formula date question
Sorting by Group of Cells
how do you retrieve a file that was overwritten in error?
How to match and sort
Won't let me copy and paste from Excel to Word
Excel startup and named worksheets
Excel 2003 - Replicating Formula in Column
automatic backups
Need Help
Copy cells to variable number of rows
Backgrounds in Excel
Is there a better way?
Filter
Formatting (macros or templates)?
Help with 'Auto_Open' please...
date of last friday of previous month
Calculating with filtered cells
Removal of link to database
revenue ranges in scatterplot graph
Data Validation
Forcing data value in a cell
Excel 2003 - Linking Formulas, Worksheet to Worksheet
if elseif
Excel program
Multiple vlookup
Why won't cell accept any formula ?
Linking from external application Crystal
return a zero for error
criteria for Pivot Table
Extract values from formulas
pivot table
Strange Excel Problem.....
Fill Down Excluding First Row
INEEDAEMAIL @PASSWORD TOGET TOTHE LABEL
shortcut to go to previous location or cell
Opening Acrobat Reader using VBA
hot to get + sign on positive nos
Custom Formatting for Dates
IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25
cannot drag to server
On status bar, sum of selected cells doesn't automatically appear.
undating new value while keeping the old
How do I eliminate Group on spreadsheets?
no blanks
Excel : fill by example
Excel, date
Problem with draging a formula,one cell value fixed,trivial question
Date Format Problems??
Negative number returned as zero
Change default height/width of up/down arrow, heading, bottom bar
Locking range in SUM
Re: Subtraction brain block
Disable warning for negative numbers on log scale plots
Make input in one column determine dropdown list in another.
Excel and web interaction
is there a way to hide a whole worksheet in excel?
Re: Subtraction brain block
how do I get alt-enter to expand word wrap cell
Text to time convert
Disappearing Task Pane
Conditional Formatting
Calculate a Formulae
pivot table error (25000 rows!!)
Excel Dummy - Please Help!
Custom View Dialog Box
Excel Solver Issue
Record data on two lines
Arbejdsliste med dage
showing all tabs at bottom of page
access to autofilter with protection
access to autofilter with protection
sorting a range
How do I set up a random Colum 1-55 without repeating a number
calculations quit working
creating columns with data from offset rows
i need to set up a songlist for my karaoke please help
Excel?
Changing the Helper Column
how do I get rid of extra rows
How to format the date in different cells
I have pop-up post-it notes on my excel sheets!! they are not comm
can i export a high resolution chart from Excel
Extra Row in Defined Print Area
illegal operation: invalid page fault in moduel MS097.DLL
Based on one cell criteria to change the rest of that row to a col
is this possible?
Why do macros show up while opening document, but were deleted?
Can formulas stay as they are when copied to MemoryStick?
Making a new list
copy worksheet to a new workbook with formulas .... but new file not point to old one
Shift key to disable macros not working
Address query
count the # of consecutive negative #'s in a range
Create filename from three cells and get to clippboard
I have downloaded a .xls document I cant open need file extension
Why Excel 2003 can't stop slececting/hihgtlighting cells?
How do I export email contacts in Excel into Yahoo?
Upgrades
Counting Date Changes
Counting Date Changes
Counting Date Changes
how do i add rounded numbers?
Default Custom View
Alternate Color Lines when using Custom Views
Help Please!
Drop Down List Font
Printing labels from excel
Record information is on two lines
The sheet path file name ?
New sheets using excel templates
Exxporting Macros
IF SUM
Filters Q
enhanced conditional formatting
Averaging Times w/ AM PM
Conditional Pictures
Most frequent item in a list (excluding zeros)
Is it possible to have a 3D sumif result?
How do I convert csv to columns?
How do I sort linked cells ?
Change Time in a Cell from [hh]:mm to decimal value ie 16:45 - 16.
Color a single digit in a mult-digit number cell
e-mail addresses in excel spreadsheet
unintentionally changing SS
How do I see a .ESP image (logo) that is inserted in a worksheet?
Excel view backwards
unknown links
How do I locate duplicate records in Excel?
Mirror spreadsheet?
matches
Limitation of Excel 2002
need to replicate insertting a row from 1 worksheet into another
Rotate the text in a sheet name
Footer... Entering Serial Nos and incremnting daily
Create fields in a form with a fixed length
Startup Problem
Dynamic Range and arrays
Page Subtotals
how do I restore background grid in Excel?
How do I get a "&" to print in a header?
using scroll mouse in excel 2003
How do I execute buttons in Excel using a voice command?
Sorting by Colors
MINIF /MAXIF Or something similar
How do I reference a cell that is #NA?
How do you get the sum of 2 different text values?
Fill colors
copy subtotals to new excel 97 book
How do I replicate data from primary worksheet to other worksheet
How can I enter a cell in excel with hotkey or combination off key
[B]Conditional Macro?[/B]
Conditional Chart/Graph?
VB Macro
How do i use multiple splits or frozen panes?
Copy and paste automatically
Using a range variable inside a excel function
Excel Only will not print.
Drop downs in Data Form
formula support needed
Concatenate multiple rows and columns into 1 cell
calendar option to choose a date in excel
Data Form
pivotal analysis?
filling information in cells
VBA can't run if the regional is set as Turkish
how to split data into columns and arrange the resulting data
Click in cell w/ formula and get colors in referenced cells
add a attachment button
Automaticaly create montly calendars for 30 employees
Moving rows from one sheet to another based on a particular cell v
Refreshing a User Defined Function
How do I enter a date range ie -7 from current date in MS QUERY
how to copy the same cell across different work books into another workbook easily?
Do nested subtotals have an errror in Excel 2003
Automatically fill one cell in any newly inserted row
Aligning Decimal Points with non-numeric data
Spreadsheet Tabs
Printing one row at top of every page
Averages excluding certian data
Using "contains" or "part" in VBA for Wksheets
Looking to create a simple user form with lookup
Re: Export data to sheets based on value
Protect an image.
Preventing Movement in Protected Areas in Microsoft Excel
Wrapping Text Doesn't Work
Web query time out problem
Can't sign out!
Background Printing
Annual Percentage Rate
Finding all your posts
Negative Numbers in Cells
linked workbooks
Can't open file in email & explorer, but excel opens
How can I find and delete tabs and carriage returns ?
Turn off collation permanently in Excel
User Defined Function
copy a list of items from word and paste in cell
Keeping cell formatting
Array
Relative input for formula
Can someone tell me what is wrong with this code?
shortcut with command line switch probs
problem with dates in csv file
Using CORREL with arrays containing null values
Square cells in Excel
change background colour
HOW CAN I PUT GRAPHICS/PICTURES IN A COMMENTS BOX IN EXCEL
EMAIL EXCEL FILES OPEN IN CORELDRAW NOT EXCEL?
Book.xlt - Startup Problems
Help please! Lookup/Index query.
Split numerical vales joinned by && into individual rows
Pivot Table Memory Issue - Excel crashes
Strange result in Excel 2000
summary count of unique numbers
HOW TO: Increment column by7 but row stays same into new column?
how to change all the words of one type(Gunsuh type)to another
Number format
new sheet the cell doesn't let me type words & numbers
How can I transpose rows to columns in a large worksheet?
problem in date time picker size
Tricky ... Pullout related rows that match a single word using Vlookup
Formula Length
Navigating a large database?
making multiple columns when printing long datasheet
add cells conditionaly not in continuous row or column
formula with moving range
I need 5 conditional formatting rules-excel only allows 3
Advanced Sortting Issue
Copy Conditional Formatting
Why do margins change when a file is emailed?
Link problems!
How do I use the keyboard to move between tabs in a workbook?
Cannot load
Can Excel evaluate a series of numbers
if statement
Can't delete columns
unable to load "Excel" analysis toolpak tried the tools and brows
not delete worksheets from names in a range
Shortcut Keys -- quick find
create pivot table formula without the GETPIVOTDATA function
Email, forms, Excel, Infopath, Sharepoint
How to remove comma and decimals from a value
pressing control minimizes the sheet
Formulas across worksheets are not updating
Default numeric value
histogram, wrong input range
Could Use Some Help!
Need Excel sheet-calc compounded future value of quarterly flows
Searchable text field
Compare if same month in cell vs columns
Adding Days:Hours:Minutes
2 different fonts in a cell
add inside borders
Sorting Problems
lookup > 0
PAGE NUMBERING IN EXCEL
Replace Function
Inventory List Question
Preventing extra Worksheets when drilling down in Pivots?
Hyperlinks in Excel
recycle bin
Count formula Help...
Advanced Filter for exact value
How to link cells only if...
Using formulas
Formulas!?!?!????
Formulas!?!??
Combine two or more columns by using a function
Autofilter - Excel 2003
auto fill options
Excel & Outlook Personal Folders
Pivot Table Fiscal Years
Copy Data From Filled to Empty Cells
Linking Formulas, Worksheet to Worksheet - Excel 2003
Add a comma at the end of a word in a cell
Can't format cells
ODBC database query
pivot table cause file size to grow
Sorting Issue
Edit mulitple hyperlinks
Concatenate and Proper
undoing conditional formatting
Macro that password protects a sheet
How do I use conditional formatting on all rows based on data
Find Replace Number Starting with 0
blocking cells
Rounding and Multiplying
Using SumProduct in VB
Excel Crashes after Inserting New Worksheet and Closing the File
Why is my trace dependents button inactive?
corresponding data
round up a function RESULT
Area prints as A rea, How do I fix this in excell?
Ripping my hair out, please help!
Problems after user copied XLS file to different folder- Help
fill cell value to the next empty row
worksheets
excel to word
how do I get data from one excel spreadsheet to another
My links won't update!
How do you make an excel worksheet cell a perfect square
excel conditional formatting default
Format Currency
Lookup function on the web
Can't find Report Manager in XP
How to format two repeating XML elements w/o getting list of list
Superscripts and Subscripts
Calculation with Working day of the year
Can you sort with check boxes?
Status bar (or similar) to appear whilst running a long macro
How do I change "Doe, John" to "John Doe" in Excel?
How do I make excel hide columns when it says cannot move objects
Start Macro Daily task
Autofilter- show dates differently
Can not copy a worksheet to another workbook
undo changes
Need to Concatenate
Open other another workbook
How do I use an IF statement to pick between two lists?
counting unique entries in a list
Print File
histograms
Percentage difference calc that knows the largest figure
A challenge for a real Excel Expert (Bob Phillips for instance)
Advanced Filter
Autofill Until
how to do a 50 day and 200 day moving average
Search for data using 'contains'
Creating Hyperlink in Excel to PDF document???
Message boxes
to use workday function in excel vba code
Find text in another workbook and paste if found match - VBA
How to separate data....
How to import plain text into workable tables/cells?
Protecting a worksheet containing XML List
Horseracing Problem
Regular expressions in Excel
Can the sum of 1p + 3p be calculated in a column in Excel?
How do you use EXCEL formula in properties of file (cell content)
Preventing new worksheets from being created by PIVOTdrill downs
activate a cell value through a macro
Backup file for excel
Printing problem
2 questions: Using solver in Macro AND converting to Word document to print A3
Changing Tabs to Specific Cells
Formulas not updating
Template for Activity Log with Sorting Capabilities
getting the sum of a column with #N/A values in it
Which Excel and Word will work with Windows x64?
What is formula to repeat row at top when column headings are numb
Data searching between sheets
How do I set a maximum value for the scroll bars in Excel?
how to force uppercase
Filter and Page Setup
navigating between worksheets
Saving in Excel
dget or dsum? that is the question
first time linking worksheets need some info and help
Need Help with lookup values in Table
Change cell to red when date in other cell is red
How do I link live stat updates on NFL.com to fantasy team?
SUMIF Problem
RE: Saving in Excel
Linking between workbooks and getting #REF error
Data Entry problem
RE: SUMIF Problem
Excel Changing hyperlink
How do I implant a field into a cell?
Converting files for Excel
RE: navigating between worksheets
embedding a long word document
Coding help request (I think?)
RE: dget or dsum? that is the question
What Happened to Voice Messages?
data in cell
RE: Data Entry problem
RE: SUMIF Problem
need formula to search column for a word and return another word
coloring in rows
Change cell color based on contents
Autosizing labels Excel 97
Do loops
Search and Display Formula
pivot table - cell locked
Filtering Data
Axis label that corresponds to cell
Unique Values Between Two Multi-Column Lists.
Conditional links
Find Discrepancies between Worksheets
Can you open a new spreadsheet in a new program window?
shortcut for indent
What is Excel hotkey for cell lock, C1 to $c$1
linking a file to another linked file in excel
Error Message
RE: What is Excel hotkey for cell lock, C1 to $c$1
Sub-Totaling
Saving Print Settings - Customized for each user
Matrix/array question
How can I put an image behind text in excel?
Newbie Help. Is this possible?
lookup a value "greater than" 0
auto fill state and city from phone number?
Check for Alpha characters
Excel xp giving me CAN when I want CNA entry in a cell.
"Show Windows in Taskbar" option from the Tools>Options>View broke
If Statments containing letters
Extracting an integer from text
Suggestion about a formula
keyboard command used to select a range of nonadjacent cells?
cannot send excel worksheet (sheet only) to mail recipient
RE: Suggestion about a formula
RE: Suggestion about a formula
extract name when a date in another cell gets near
display
RE: keyboard command used to select a range of nonadjacent cells?
What is the default alignment for values in Excel?
RE: display
Filtering on a formula
How to SUMIF multiple ranges?
Custom Validation
Can you get line breaks in a text cell
Move 2 cells to right
Show last number entered
data sort incorrectly
Autofill until
Formulations?
date excel
Why do I get an error Document not Saved in Excel?
Dual monitors
I think this is either 'IF' or 'And'
Strange formula popping up
Can I concatenate text in cells to make a working formula?
need cell validation formula help
Unable to View Sheets in Workbook
How do I rotate a grouped object in Excel?
How do I match identical values in 2 columns and then sort?
select and paste
Leading zero
Install dates formating using conditional formating?
formula to extract partial content (text) of cell
Fuzzy matching data
Line breaks in Excel?
pivot table SQL2005
Insertion of existing worksheets in current worksheet
How to add totals in one sheet to another sheet
Auto insert page breaks in Excel, based on a sort of numbers
Change email addresses
Formatting
Conditional Autofill
Help needed to add commets, arrows, etc to existing graph...
Identifying/Eliminating Worksheet References
I want to do a horizontal list - only 4 options chosen with mouse
After protecting excel unable to group & ungroup few colums
worksheet open
Cursor Appearance
change date format from dd/mm/yyyy to mm/yyyy
Please help me with my Excel
How do I add input data in the input ranges in drop down boxes.
Mobile Phone Calls
Batch change
creating fax forms
"Cannot Group That Selection" in a Pivot Table.
Any way to highlight rows without using macros?
importing csv
how can i change dates from US to UK format
Open an Excel file with a date as today in a macro
Excel - fill white space in cells
text field limit
How do I save a workbook as a new workbook by using macros?
Lookup data in other workbook
Linking information form one worksheet to another
DIFFERENCE BETWEEN TWO TIME STAMPS AS DECIMAL
How to change date from US to UK format
date
Get Excel to accept negative values using time-format
if / or formulas
Hyperlink to specific Form in MSAccess
convert from .xls format to .csv format
Fill Query
How to import a table on a Web page to Excel?
User guided button???
PDF to Excel
Sumif using dates and positive negative values
Get month from date
ignore negative values when adding
Wrap text in column headers to fit text in column
How do I stop Excel from converting a numerical entry to a date?
sumif using today's date
excel modular sheets subsheets
Using visual basic to select what paper to print on
if then else statement also using "and"
=SUMIF(Rewards!$AH$3:$BI$3, ">Targets!O30:<O31", Rewards!$AH$20:$BI$20)
excel postfix number format
Aggregating data
Saving Posts Questions & Answers In My Computer
How can I add a two letter prefix to text in cells?