Microsoft Excel Misc [Archive] - Page 149

Pivot Table Help With Market Values
Excel 2000 can't open Excel 2003 workbook
Converting Works 2001 Spreadsheet to Excel 2003
Auto-updating top-list.
If / Lookup / Filter type formula ,..?
Excel 2003 - Filename as Footer
Help With Using Live Data - DDE
Count Help
Matching
Does anyone know why Excel starts with all menus locked?
i would like to know a formula on how to round a number to 500
over, then down feature under page order in Excel
how do i make text fit into 1 block in 2 or more lines in Excel
Matching data
Paste Link Problem
Count
How to synchronize different Excel files
Using Live Data Input Help (DDE)
Extra characters exported in unicode(.txt) format
"Merge" cells
Data Validation
Page setup - footer
Add Zeros to Numbers
Help on any part of this would be great
page breaks
permanent cell protection
finding the common names between columns
How to streamline this Formula?
How to calculate number of month from 2008 in Excel?
How to narrate the numbers ?
Multiplying
Linking Files
Subtract two dates
Insert same picture in multiple sheets and only change once
delete tempfile in excel
Vlookup
copy absolute figures and not formula
excel cell lookup file on harddrive
Changing a date back one month
allow text to overflow into the next cell?
Data Broadcasting in Excel
Remove Main Toolbar
Quotation Marks - When and What??
*Salvation Army* Importing information from one workbook to another
Font within concatenate
Drop Down List Question
count highlighted cells
Need help w/ formula to sum time worked based on two values...
Creating links to graphic file
excel 97
missing menu in excel..help!
Why does last number of a 16 character number always change to 0?
Copying a formula "literally"
Comment Box Position & Pointer
Office 2002 excel search
What keystroke(s) drill-down in a PivotTable?
Finding the median of numbers meeting criteria
Cell displays '#######' despite column widening
Pivot Table Page Break problem
How can I make the top row of my spreadsheet non-scrollable?
Bank Check Template
total work hours for 24 hour on-call schedules
Highlite every 2nd row with a colour
format a merged cell to grow (Heighth)
Need for More than 256 Columns
excel to csv export
Consecutive Days (Not NETWORKDAYS)
URGENT !! Auto Filter
maximum calculations per excel workbook?
Locked by User
How to split a worksheet
Form Drop Down
Problem printing a large excel cell
Excel 2002 - Date format keeps changing
conditional formatting: problem entering EOMONTH formula...
Users submit and charge for templates in Office Applications
123 menu to the left after subtotaling
RE: conditional formatting: problem entering EOMONTH formula...
How do I format numbers in thousands?
Excel
RE: How to split a worksheet
Convert/import into Excel
Ignore file links that do not exist.
Lookup Help
Excel Pivot Table VB Code
RE: URGENT !! Auto Filter
How do I populate a worksheet name in a formula using a cell ref.
RE: How do I format numbers in thousands?
Sorting and merging cells
Pivot tables
Userform
RE: Lookup Help
Excel: copy and paste only shown not hidden cells into new sheet
Changing Pivot Table Source from ODBC to .odc.
IS THERE ANYWAY TO RETRIEVE A PREVIOUSLY SAVED FILE ONCE IT HAS B.
How do I convert a single column of addresses into rows for export
Is it possible to use 2 different fonts in 1 excel cell?
Excel -- paper symbol attached to cursor?
RE: Lookup Help
Dragging Formulas
I need to print many copies of a document, how can I number them?
How freeze streaming data at specific point in time?
Excel spreadsheet
Hide Unhide Rows
Excel 95 had a "data analysis" option, how can I access on XP?
Manual / Automatic Calculation
Set defaul to "text"
formatting page numbers
can we link fields from a form in word document to excel
RE: conditional formatting: problem entering EOMONTH formula...
formula for range values question
Using "if" equation that requires auto update
Remove top bit characters
Suppress printing workbook
hi
hi
keep cell as text, not number
formula construction
Random Item
Random Item
Is there any way to keep the Task Pane (pain) from displaying?
Embedded excel sheet in outlook question???
Password Protection
excel duplicates on 2 worksheets
CSP 5.6 : make your Cutting stock patterns in less than a second!!!
unique records in Pivot Table
Recalc Options in 2003?
Can you enter @ symbol without becomig email address in a cell?
can't format column for date
Combinations
Is there a formula which will print the sheet name in Excel?
Club Dues collection report and statement setup
Sumproduct?
RePost: Protect
CSE formula results
Auto date entry for status change
Capturing data using a formula
Agenda Time Formula
Converting words to numbers
Excel Search function
In Excel Tools Menu Option Dialog box don't open
Why are column names in numbers instead of characters?
Auto Open, Refresh, Save, Close
Copy exact value from one cell to new formula in another cell
RE: Printing spreadsheets macro
Unable to Record Macro
Data entry in multiple worksheet
Multiple Unhide - is it possible
Copy cells in a determined order
Pop-up error msg: Too many spelling or grammatical errors
Changing the scale major unit in a graph
Text Colour Within Formula
Limiting edits
INSERT A PRINT BUTTON ON A WORKSHEET
Spreadsheet Question
function the ^ sign
MS Excel is too slow when formatting, setuping page, etc.
Creating Links to files in a shared directory
custom menu
Coverting an Excel document
how to set highlight for row/column header
why is the data row in pivot table incompletely shown?
numbering add-in
Numeric in Text to convert back to the form of Numeric for VLookup Purposes
Dollar Sign
Pivot table for reporting sales performance
How can I make a cell mandatory?
Elimnating subsequent cells
find text in column h and total the corresponding numbers if colum
How do I change the size of check box in forms control?
Converting Wrong Time Value to Correct One
Excel worksheets will not recalculate a
How do I use advanced filters in excel?
fonts missing when using Insert Symbol in Excel
Can I change the default paste options?
merge affecting dsum calculation
How can you remove all objects in a worksheet at once?
count how many times a button is pressed
VBA project is protected
Whats wrong with this macro please
Genarate a fixed date with an IF function?
pari-mutual wagering spreadsheet
Rename Macro
How can I insert same word into selected column
Protected power calculation spread sheets
working spreadsheet from several workstations
Excel practice sheet. Can't view instructions.
superbowl betting Squares Sheet
How do I protect a single cell in Excel 2002?
Sum if formula to include value in col Q when no value in col P for that row
conditional formatting
Organize contacts with phone numbers?
VBA using "Cells(i,j)
Format Excel column as Upper Case without use of UPPERCASE formul
How do I print my "Windows Media Playlist"
Calculating Cells across worksheets??
Re: Excel VBA Macros
Sorting
merging documents,exporting long landscape table to word with page breaks & numbers
macro: combine / modify date / hilite
vlookup problem
Excel Add Ins - Funcres.xla and solver.xla for office xp
Excel User Conference - Last day for the registration drawing
Conditional Format
Need to convert #,# into #,#00 or #,## into #,##0?
Need to convert #,# into #,#00 or #,## into #,##0?
how do i hide columns in excel so no one can open them.
# in cell
Re: Sum of numbers with dependencie on another column
pulling through data from another workbook
How can I conditionally display one picture over another?
summing according to groups
Compatibility
Problem with Autofilter
to AND or OR remote reference?
I need a Treasury Bill calculator
If Statement - Need Help
Adding a prefix to all numbers in a column.
when i move or copy a sheet, dates change by one day??
how do you regulars keep track!?
Question aobut splitting a number
Excel Add Ins - Funcres.xla and solver.xla for office xp
Excel Genius Required!
Worksheet Cell Range Name within VB Subroutine
Continually accepting the "User Agreement".
Formula for billing water
Update cell reference within a formula
Where do I obtain a rebate log templete?
How do I get an average for 5 when I need to skip cells?
Formatting cells, Need help solving a problem with excel
preview pane
Printing Row Headings Only
i lost a file opened on top of another one
how do I find, insert in a doc, xls sheet, the symbol for PI???
how many days
If + And ....
If + And ....
How do I get more columns in a pivot table?
find a specific value in a column and write another column
One worksheet becomes many files?
RE: i lost a file opened on top of another one
were can i download excell xp from for free?
Auto-Entry of text from another worksheet
How do I use a macro button
auto reading macro
Deleting or Renaming Lists
Automatic Color Change
VBA reseting variables
How do I keep text viewing correctly as I change zoom %
Autofilter counting sorted items
Worksheet Limit
Cursor to A1
RE: Printing Row Headings Only
How do I secure an Excel invoice to email?
Looking for specific Loan Amoritization Excel SS - read below
Inserting Change Document Date
How can I lengthen the drop down Fonts list to show more fonts at
totals sheet- need summary of column of names between sheets
RE: Worksheet Limit
How can I send an excel workbook by email for recipient to update?
Get external data using UNC path
Dashboard or Scoreboard
average calculation
sumif problem
Function or formula to convert "text" month to number of month?
Help needed...
RE: How do I get more columns in a pivot table?
RE: Automatic Color Change
New smart tags added
Q: Auto filter "selected" color
Setting notification of dates in Excel
Multiple fill color buttons
How do I use a keyboard to change a PivotTable or delete a field?
spreadsheet no longer calculates automatically when figures change
Format Cells - Accounting - Discrepancy?
RE: spreadsheet no longer calculates automatically when figures change
bottom double border shorcut key problem
Import And Resize Images
REDUCING COLUMN SIZE
RE: Function or formula to convert "text" month to number of month?
Can I save excel data as it is entered?
Books Download
Roundup Function
PivotTableDestination
How do I get excel to save after data is entered in a certain cell
RE: VBA reseting variables
How to run different macro from drop-down list ???
RE: Function or formula to convert "text" month to number of month
Re: Deleting or Renaming Lists
Material Condition formula
Date
Link worksheets in Excel
FILE CRASHES
pop up menu
Edit Query
Excel Installer
RE: Date
RE: Setting notification of dates in Excel
Creating a cell name from another cell
Creating a cell name from another cell
Highlighted Text And/Or Cells
Current date and time updated automatically
How to place a value in another cell
How do I use a keyboard to change a PivotTable or delete a field?
start page numbering after table of contents
dynamic search
What settings do I use to allow Fill features to show in Excel
repost: lines not printing
IIf and value-errors
Lap Times in Spreadsheet
auto saving transfered data
Strange Prob with Worksheet name
Pvt table
2 different cell widths in the same column?
Global criteria update for formulas?
Picture Database
Excel 2003 won't read Excel 97
Sum of a range dont have to be over 8
Question on default print settings
Cell displays formula instead of result
Re: Sum of a range dont have to be over 8
Sum of a range dont have to be over 8
Re: Sum of a range dont have to be over 8
Inserting Dashes in a Column
Macro Formula
How to use literal quotes with concatenation
VBA worksheet function
How can I hide a paste button that appears?
Vlookup & Trim
How do I turn off virus scan on opening an Excel file?
find days and hours between 2 sets of dates and times
Wildcards in RTD
Sometimes a cell will not allow formatting, like borders
How to sort by ZIP codes listed in one column in Excel spread sh?
' Invoice' , change ' State and ZIP' to 'Prov and PC' How?
multiple time stamps on worksheets
Show blank cell
stop users from deleting rows
Excel & toshiba Printer
Got a serious question?
Quickie !! Split text in a cell
Last column in Excel does not sort
how do I insert a blank row when pasting?
How can I protect a cell and keep the spell check working?
Formula or Macro to hide a row based on a cell value
How do I get Excell to recognise 0 at the beginning of a number?
excel opens asp.net page
if statement for empty cell
RE: if statement for empty cell
How to move to the next worksheet if its protect
how do I increase maximum worksheet size in Excel?
Password protection of Folder
RE: Password protection of Folder
Re: macro shortcut keys don't work
formula to copy ocurrences...
Reference problem
how to select fewer cells without canceling original selection
Saving Sheets into Multiple Files
what causes "invalid page fault in module AVWIZRES.DLL"
Notes in Outlook
opening text file in excel problem
wrap
pivot table and multiple worksheets
In excel, my mouse locksup and grabs everything when moving. why
How to calculate the difference between two times - custom
401(k) Workbook help...
Printing Help
Sort Pivot Table using hidden data field
Birthdate Months
Working with Macros-Activesheet.Paste
Scroll bar - Control Toolbox
sum of 1 column if info in another = specific text
Combo Boxes Online...
Import data to a spreadsheet.
number of tasks within an hour
Column Reference
Formulas Between Different Sheets
bullet points on the toolbar
Excel - MS sqlserver 2000 connection
insert picture to a specfic range of cells
Subtotals from multiple columns?
creating a graph with three " Y" axis"
Macro To Insert Blank Row?
Subtotal count not working
How do I match unique identifiers on two Excel worksheets?
deleting products
dynaimcally organizing or copying cells?
How to use month() and day() without considering year()?
Color Options
Need help with date format !
delete a cell if
Saving Changes
CutePDF multiple files from Excel
Advanced File Editor
on particular action run a macro
Excel links & inserting/deleting rows
protect
Remove #N/A in vlookup result
Can i "series fill" a number of cells with hyperlinks?
Merge - Unmerge
Can I add files to the getting started task pane in Excel?
how to populate a 3rd column with with data from 1st or 2nd colum
Delete Code Modules Programatically
confused,please help
quick filter
Combining Excel with Powerpoint
Excel table to Word help needed!!! Urgent.
Finding a sum in a list of values
Using wildcards in lookup?
Excel 2002
Dont know if this is possible to do
how to change (555)123-1234 to 5551231234
RE: how to change (555)123-1234 to 5551231234
RE: Using wildcards in lookup?
how to convert 19900301 to 03/01/1990
How Do I specify the number of rows in Excel?
microsoft excel
Change lots of series on a scatter graph to one colour
Can't see my files
can i use mailmerge to in excel like you would in word?
RE: how to convert 19900301 to 03/01/1990
remove page numbers
Missing "Custom View" entry from View menu
How compatible is Excel 2003 with previous versions
RE: how to convert 19900301 to 03/01/1990
remove page numbers
cond. format for hilite every 200 lines
RE: Dont know if this is possible to do
How can I match up values from 2 sheets and info in adjoining cell
Re: cond. format for hilite every 200 lines
Can an array be made of discontinuous cells of the same row?
RE: Excel 2002
how do I get excel to change the last digit in a cell
Excel Files Changed
Excel
Absolute Path change ...
Macro lookup
Insert colon in text in cell
Microsoft Office Excel cannot paste the data
Stop recording macro toolbar
Re: Password Recovery
If Then formula - Should be easy!?!
Excel 2000: sum function automated?
Extract data that has increased by a percentage
Saving to a worksheet in another file...?
I need help with deleting duplicate, and the original cell, row.
Macro broken with workbook name change
Filters
What happened to the Office Assistant?
drop downs
i want to Fill Color in a cell but dont want the colour to print?
Excel 2003 Formula Bar
How do i keep cells blank until the formula is used?
Copying groups of dates
How do I remove a check box from a worksheet in excel?
VBA Boolean
Sort by Month and Year
sumif if cell does not equal #N/A
copying object into word
No Define customer colour?
Using a cell reference as part of a link
Ranking Formula
Indirect question
How do I count the number of days from 1 date to another?
Validation- Drop Down menu size
Search & Edit in Excel Database possible?
How do I turn off autoformat for .CSV (comma delimited) files?
Restricted Usage
Page numbering question
Check Box Text
Can Excel help me do this?
Secret Menu
imported doc from pdf file, want to seperate text & date in cells
Lookup table returns #N/A
When linked objects update in Word,it keeps changing the spacing?
Re: Auto Save
Modified files
Number of tasks completed in a specific time frame
Can you delete all hidden columns in an area in one move?
Error from losing power while writing macro. Recovery help?
Workbook fails to open - Excel 2003
Splitting Information in a Cell
Count items on the list
Search Columns & Rows
Drawing data from different filenames
How do you get traffic lighting to work in Excel 2003
Hyperlink change address
increase number of files listed In the drop down box on my compute
Eliminate Duplicates in Pivot Table
Searching Columns
Query doesn't add/delete data in rows on refresh
sheet names
Suddenly unable to re-format cells
Hlookup Macro
HOW CAN I ADD DEGREES IN EXCEL?
Format date with just month and year
Outlook attachment to network folder
Start page numbering elswhere.
Lookup based on two criteria. . .
HELP ME PLEASEEE- how to format data in a column
Connecting image to cell
Ho do I do this without a circular reference?
Export notepad file to Excel
Defined number of characters
If Column A = X then put in Column B Y
Using Access in Excel VB Code
How do I transfer my Word & Excel files to a new computer?
Automatic absolute formulas
multiple numeric values applied to single text
Place picture behind text
I want a title to print on every page of a worksheet; not a header
Sorting 1st, 2nd, 3rd...
Excel Columns should be referenced in numbers not letters
WorksheetFunction Class - Random values from LogInv needed
WorksheetFunction Class - Random values from LogInv needed
numeric value is not formatting correctly
Excel 2002 Add-in: Access Links
Can you convert Excel column indicators from Alpha to Numberic?
Excel Formula
How do you use a comma as the line terminator when saving to csv?
macro trigger
Validating cells
Capital Letters Only
I lost a spreadsheet, can I retrieve it?
RE: Can you convert Excel column indicators from Alpha to Numberic?
New to macros! Need Help!
Can you paste formulas with no value so Charts don't registerthem
delete a cell if it contains specific word
Update Macro: Leave Colour As Before Once Cell is Not Active
save excel workbook
Referencing numbers
Rounding Question
Blank workbook opens when try to open any existing book
Deleting results of an AutoFilter excluding top row
Check Mark
efficieny
efficieny
PRINTING
Excel User Conference - Atlantic City, April 19-21 - Registration Giveaway
Change Formatting In 'Active' Cell
MATCH Formula
Circular reference problem
how can you see what is updated when linking workbooks
Round-down complex numbers
Copying a Formula which contains a link to another worksheet
Deferring conditional formatting?
HOW TO CREATE A FORMULA TO AUTOMATICALLY INSERT THE DATE
Formula to limit the size of a number result in a cell?
import web data
How can I increase the cell data in several columns by 15%
Ways of Summarising data
Disable auto-formatting dates.... GRRR!
How do I save a xls sheet as XML Data?
How to set Header Row to repeat on each page
Save as Web Page
How can i set one row to repeat print on every other row?
converting ascii csv to .txt for financial data
Pivot Table - too many rows/columns error
Loosing correct hyperlnk location after sorting spreadsheet data
Excel 2002 - link columns across workgroups
FindFirst, FindLast and select
updating a cell value
Time Display Question Please
Error ExportPicture in PivotTable
inventory formulas
Cell Format
Vlookup formula
how to make a rolling calender where hours roll off after a year
Adding using Vlookup
Is there a shortcut key to move between sheets in Excel?
find last row and select whle row for format
#DIV0/! issues
trigger problem
How wide is a font?
Macro to hide blank cells in a range
Calculating revenue based on accounting months
Printing black text only
Protecting multiple worksheets.
Saving a workbook separately to its macros
Web queries & Yahoo! Finance
Open multiple spreadsheets, but close only one
Orientation of multiple data items in Pivot table
Format numbers to millions
data validation
FILTERING SINGLE CHAR
Multiple split screens
automatically insert 8 blank rows between each record
macro not working
Excel and Quickbooks
Calculate Business without the use of the Add-In (Analysis Tool-Pak)
Timing a macro
counting characters in a line
Formula for Displaying the First Character of a word
linking one worksheet to lots of workbooks(worksheets)
Lookup value help
sending email from excel not working
Lookup in a range.
in excel, how to limit digits of negative hexadecimal numbers?
If Statement looking at more than one sequence
MS Office Excel - Font & Fill color
impossible way to do something?
Worksheet reference
Remove element from menu
Find all results dialog box
Excel Spread Sheet
How do I keep excel from changing minute and second times into AM.
HELP - Excel 2003 VERY SLOW vs 2002
how do I create a vlookup?
huge huge excel file... why?
How do I change the dates for attendance calendar 2005 to be 2006
change form from top to bottom to side to side
Require a cell to be nonblank if another cell is nonblank
2 worksheets in 2 windows
Blank worksheet
Dropping the cell in the empty cell by formula
In EXCEL copy sheet layout to another sheet
Visual Basic Error when opening Excel
Autofill/Autocorrect
EXCEL HAS STARTED ROUNDING TO THE WHOLE DOLLAR
fuzzy match
Macro for hiding rows
Comments not anchored to cells
HOW DO I DELETE A REPEATED TIITLE IN THE HOME SECT. OF OUTLOOK?
Excel/Access
Auto Borders
Excel 2003 - PAGE SETUP - FIT TO WIDTH does not work
How do I make my spreadsheet uniform for (negative numbers)
Businessday (Networkday) Function
if statement
max number of sheets possible in a workbook?
Transfer existing digital certificate
Editing cells is elogating spaces
Excel project for credit
Tote betting
Sumif and changing array
Is there a way to sort worksheets within a workbook
How do I repeat a row of headings when printing an excel spreadshe
Separate characters in a string
Use of Parameters in Excel
How to sort data with rows that have subtotals
OFFICE 2003 DOES THE CLIP BOARD
Saving a cell name as a word doc
Show % Difference between two numbers
Printing Transparent Graphics
Format
Re: Excel Password Recover
How do I create two separate instances of Excel?
How do I identify duplicate numbers in Excel?
error message during printing
Excel referencing across sheets
Password redundant through use of cancel
ss:Formula in excel saved in xml format
getting a total for a row of cells where some are text
minimized buttons do not appear on taskbar
RE: Excel Password Recover
error message during printing
Selecting Non-Consecutive Variables
Printing rows on every page
How do I "unassign" a deleted Macro from an object in Excel?
Printing from default printer
Removing zero values from a spreadsheet.
Lock a hidden worksheet
Similar to Vlookup
Copy Spreadsheets
Worksheeting printing when excel is closed
table help
Sorting 1 column into two
Conditional Formating
how to hide raws and use password
Create four columns out of one
Solver solution hessian
Cell formula where result to be Positive only
When I doubleclick in Excel, page jumps down/up.
Drop Down Menu
Read list of cells; conditional
Blank (empty) cell always equal to 0??
Count-formula used for words
Date Format - April error
Excel 2003 - Freeze panes
Displaying a different value
Checkboxes vs. Option Buttons
Styles in Excel 2003 - where is the ability to assign key-combinations?
Naming a range
conditions in "countif"
backup copy of a workbook
Sheet tab Restriction
backup copy of a workbook
paste excel sheet excluding hidden rows
Naming new worksheets
query multiple excel files
Unable to open webpage error during a web query to https site
cannot open this file
How to change an other cell's value?
Changing an Access Query in Excel
conditions in "countif"
Auto filling cells across mutliple sheets
cannot open this file
protected sheets and hidden rows
Excel2000: Weird behaviour in VBA
How disable menu command on excel view
Links In Excel XP
internet explorer instance
#Value Error?
Worksheet has disappeared
Excel 2003 - turn off option in autofilter
How to automtcly update th date in cell if info in row changes?
VBA code is being deletd from WorkBook
Numbers read as text
VBA Code Help
Spinbutton
How Do I set a minimum(or default) value a a result from formula
Another Average non-adjacent cells question...
In excel how do i get a chart and graph to fill the page?
Formula Help
Time formula
Data conversion
Short cut to move back to last position
Filter
Sum of like items
excel help needed
Importing HTML data into excel
Easy question? Page numbers
converting data in colums to rows
How do you remove file bloat in Excel?
Query, copy & paste
formatting question
Why would autosum not be working?
Product list to match price list
Header repeat across Sheets?
Formula Help
Excel Get External Data
Rounding Interest to nearest eighth
Re: Check Box
Check Box
#DIV/0! query
Re: Excel column sum, part 2
Waterfall cashflow distribution
mouse stuck in cell selection mode
Re: Excel column sum, part 2
RE: Templates
RE: Can I go beyond 65536 lines in a file?
Re: IF statement help...
Working with times
Outlook Template for Student Use Based on Points
How can I fill in the required fields on my spreadsheet?
Excel column sum, part 2
RE: Sorting in Excel
Can I go beyond 65536 lines in a file?
IF statement help...
Templates