View Full Version : Microsoft Excel Misc
- Re: Show formula as text
- Excel XP crashes when printing, etc.
- Want Excel fractions to print like Word fractions
- Formatting numbers in a mixed text and numeric formula
- Re: VBA for adjusting row height
- Copying & Transposing #'s
- repost - using formulas
- Days Elapsed Formulas
- micro for multi colors in a cell
- Tracking "Date Last Saved"
- Importing an old workbook into a new workbook
- Excel file size blows up when inserting pictures.
- Re: q Faxing From Excel Using A Macro
- Data comparison
- Validation
- EULA
- saving as html
- Removing Macro Screen At Startup
- vlookup
- Hyperlink to bookmark
- Excel settings
- Offset Errors with Ranges
- Macro Buttons
- Coloring a group of cells?
- Using FIND in comments
- 2000 & 2003 Compatible?
- Excel Error Message!
- VBA Password Recovery
- search
- CSV truncates after 15th record
- Strange Message Box in Excel
- Kill Excel silently
- Top 20 Values
- Re: linking a "read only" Word document into an excel document
- Importing Files
- EXCEL TEMPLATE
- Excel file names
- No Maximise Minimise
- method of selection
- Excel slow to open large HTML file
- Help please!!! Conditional Formatting
- deleting a recordset control
- Shared workbook question
- Sum up values that falls between two specific dates
- filtering .xls files
- Excel and "AutoRun.inf" -- help
- Vertical Tabs
- Excel recalculation problem
- need a function to repeat a process
- Excel tries to access internet
- Strange result in pivot table
- Converting Word into Excel
- Formatting the Formula Bar
- countif using cell refrences within a string
- Set Left and Right Margins in Headers and Footers
- Conditional formatting
- Macro or IF statement - HELP!
- Formula view with no resulting value
- Protected sheets and running macros
- Encrypt or Hide Macro
- Change #N/A
- check if cell is part of range
- Report Manager in Excel XP
- Re: Excel - MATCH, INDEX or VLOOKUP - That is the Question - URGENT
- excel autofilter arrow custom query
- re-run macro automatically ?
- No data in spreadsheet
- Help with a simple formula
- Excel Vba- Userform stopwatch
- password protect a macro
- Cell problem - cell displays formula instead of value
- filtering colours
- Linkage between spreadsheets .... link from file1 sheet3 to file 2 sheet 1
- xl2003 "cannot save - folder marked read only"
- changing and constant variables in a formula
- Select Records for Subtotals Based on a Given Condition
- vb--simple simple
- Open windows explorer
- Cumulative Totals
- Divide by the amount of filled in months
- Conditional Formatting of Numbers
- Safe Mode
- Re: A Report
- Print 1 Column in multiple Columns
- Chaning the color of the coment indicator
- Bubble chart- names for values
- ODBC error with no help
- IF two different conditions are met
- Custom Toolbar problem
- Re: setting values for cells based on previous cell
- menu bar disappeared
- Opening Workbook to a specific cell
- Links showing #VALUE!
- Database export, all data in one cell
- combo box range
- Extra Characters When Pasting From MS Access
- VB Program for message
- Sheet Names Must be MMMM d (only if workday)
- Copy subtotals as values
- Re: Copying formatting, data and charts
- Erase numeric digits only
- Re: 97 vs 2000
- Re: Name define
- Re: Pivot tables using text data
- Re: 97 vs 2000
- Re: Name define
- format cells: divide by 100
- Re: Pivot tables using text data
- Is there a formula for this?
- Changinf references
- Summing up specific cell references and its correlating value
- converting numeric amounts into words
- Re: Copying, or at least extracting!
- Re: Copying, or at least extracting!
- Re: Copying, or at least extracting!
- Divide by 1000
- auto lists
- Re: number coloums coming up on wrong side
- Tools Missing From Standard Toolbar
- VLOOKUP with multiple references?
- Pivot table - adhoc formula
- Excel VBA - Conditional drop-down list
- Decimal alignment
- Linked Graphs
- Format Cells
- Excel asks to save changes when noen are made
- SUM CELLS
- Date format in Excel 2000
- Make all number values BOLD that meet criteria ?
- VLOOKUP AND COUNTIF
- Cell Format
- Array Sort and/or Index problem
- Re: Saving Excel 2000 file data as a right justified text file
- Re: how to delete every other row
- Headers in Excel
- EXCEL + mail merge
- Print only coloured rows of table
- Converting Spreadsheet to Table in Access?
- opening excel 97 file in windows me after using in windows xp
- opening excel 97 file in windows me after using in windows xp
- Re: how to delete every other row
- Excel 97 inserting file path into footer
- Formatting Average Time
- Subtotal in new column
- RE: how to delete every other row
- Formulas
- Inserting the contents of Sheet 1 from another file
- Looking for a method to print only those worksheets that the user has entered data into
- Printing ranges
- Chart title reference a cell
- keyboard shortcuts
- Copying Worksheet to New File
- Sheet printing order
- Custom Toolbar
- Autofit Row
- @IF Formula w/ multiple outcomes
- Re: Excel+Mail Nerge
- worksheet
- Auto-checking a checkbox based on cell contents.
- Print order problem- VBA
- Pivot Table Format
- Combining Worksheets
- Printing grayscale from MS Excel
- Cutting cells changes my SUM formula
- Excel Programming Help.........
- Excel file size
- simple list box question
- Copy Worksheet Question
- Generating Data based on a List
- Re: Name define
- Yearly tick marks on the x axis
- Re: Copying, or at least extracting!
- Re: Saving Excel 2000 file data as a right justified text file
- Time arrrggghhh
- Survey forms??
- HUH?
- Fill Colors Only Appear in Print Preview
- Excel 2000 date formats
- Compensatory time formula for a Time & Attendance Workbook
- internet explorer mime type resubmit to window error
- referencing workbooks
- Macro Propagation
- know the timing in advance
- Web Query broken in Office XP (worked in Excel 97)
- Keyboard Shorts for Common Operations
- Re-post with e.g.
- Convert Text to date
- Combo Box
- Comment Indicator Colour
- Help With Restricting Values in VBA Data Entry Forms please
- Concatenate
- irritating icon
- Copying data from another Exel File
- Extract list of unique words used
- Deleting controls
- to find numbers and delete
- reverse a pivot back to original data state
- OnTime problem with multiple open workbooks
- Convert to Date
- Breaking a link
- help with cells formatting
- Grabing Data... Saving.... Repeat
- Rounding
- formatting a cell
- Help with inserting lines
- Matching two sets of data
- excel vba - if "x" = 0 or less than...then
- Showing numbers to the nearest thousand
- Help
- Changing language in Excel
- Re: currency
- Merging with Word
- Excel for Macintosh: using US Census data
- Match Function
- currency
- Re: need help with formulas/vlookup
- Print button on toolbar linked to specific printer, way to do?
- Re: need help with formulas/vlookup
- Autofilter in protected worksheet
- Using macros to filter
- Re: Office does`t delete TMP files
- Multiple IF
- Outlook contact forward
- Excel VBA - copy cells to another workbook
- conditional formatting, empty cells
- Custom Number Format
- Use of "Custom" number
- Complex Sumif and Countif
- Add the contents of two sheets together
- Formatting cells again
- movin' from sheet to sheet
- Re: Calculating the difference between two times and totaling the differences
- DCOUNT
- Circular reference "help"
- Re: Right Click on Mouse doesn't work in Excel 2003
- Re: RE-Post with link & more info
- Re: SUMIF Arrary
- can this sort be done?
- Excel date formula
- Splitting Data
- "Cannot access read-only document"
- Re: Counting unique accounts
- background text
- blank document in Excel 2000
- SV: Re: Excel sum problem
- Pivot Table 'page' field
- RE: SUMIF Arrary
- Adding names together
- How to hide rows on condition
- Excel 2002 error message
- importing quattro pro files
- Excel 2000 templates won't open
- Re: ERRORS
- Find/replace fractions
- Do not display "0" value
- sumif using more than one criteria
- Re: Calculation of mean excluding target subject
- convertion
- Macro dialog box when opening worksheet
- Extracting Url from a hyperlink
- Solver Problems
- drag+fill, but window doesnt scroll!!
- Re: Pivot tables - filtering and formatting
- Auto calc YTD Numbers
- sequential cell numbers??
- Excel 2003 . . . Can't Delete Corrupted Defined Names
- Can not find Links
- Quickly Moving Names from One Cell to Another
- Data Validation Formatting
- Pivot Table slow when changing
- Re: adding borderline per row
- Re: adding borderline per row
- Conditional Formatting based on value of another cell
- Totalling based on criteria
- extrapolating data
- Excel Save as Text with Japanese Font
- Scrolling cells under a heading?
- Excel Linksources / no object array enumerator
- Excel Programming Help.........
- Excel Programming Help...........
- Using "&" in header and having it print
- text formating
- Temp file created and not deleted after saving
- Signing Macros
- What controls default date when entering date fragment?
- Set Tab Order
- Truck Loading Models
- Outlines
- Macros
- missing object error
- question
- Fit to Page
- Autocorrect Options
- seperating time
- Re: cell format printing
- Remove Cell Auto-Format (General) on Paste / Replace
- Re: Data Analysis Tool Pak dialog does not pop up
- Re: Protection of worksheet
- inserting pics as part of data
- Re: Counting unique accounts
- Comparing 2 coulumns in different worksheets and printing the rows that match
- text formatting
- more questions
- Re: adding borderline per row
- #DIV/0 Pivot Table Problem on Calculated Field
- VBA code for a timeline chart (lookalike)
- Spell check in a Protected worksheet
- Frank, Peo, Debra - HELP!
- Greater than
- Using the fill command is there a way to increase by columns instead of row
- row height
- Cell Formatting
- Fourier Analysis
- Microsoft File Password Recovery
- URGENT!!! how to recover a excel file after saving it?
- ATLINE Function
- Being Stupid - HELP!!!! Copying results of formula
- MultiPage tomfoolery
- Excel hyperlink problem
- Stop interpreting Value as date.
- Link to access Path problems
- major help needed --timing problem
- Excel Shortcut (right click) Menus
- Excel VBA - deleting rows which do not contain certain text
- convert Seconds to Minutes
- Limit of choose function up to 29 index no.
- Re: Consolidating Workbook Values into Summary
- Graph Data Values
- Still Have Not Figured It Out
- YTD Calulation in Depreciation
- Zeros in empty merge fields
- phantom blank on right of field
- RE: Calculating the difference between two times and totaling the differences
- query destination field
- Adding a percentage to all fields...
- month value only
- Retirement Calculation Formula Help
- Excel Data appearing in new Pop-up window rather than frameset frame
- Conditions not me but conditional formatting still takes effect
- Recorded Macro, Report Manager
- Macro giving me grief..
- Display nothing in a cell if value = 0
- e-mail indvl rows to e-mail address w/in row
- # symbol apearing
- Macro insert data, need to insert rows
- transfer data to a different format
- Re: Need for CalculateFull
- VLOOKUP giving incorrect return
- exel query problem using ODBC
- Refreshing data in Excel from SQL
- auto tab
- Some Conditional Formats Not Available
- Open Minimized
- Merge and center
- Transferring cell totals...
- Excel Keeps locking up whenever I try to open a file
- Distribution lists
- excel 2003 no of cells
- Limit of choose function up to index no. (2)
- Adding cells with formulas
- Calc. Length of time with time-in, time-out, date-in, date-out in diff. columns
- undo help!
- Documents being saved mult.times
- change event
- Date calc limitations in Excel
- MATH IN AN "IF" FORMULA
- XL Symbols
- Can anyone help me??
- Need more than 256 columns
- Linked excel template to excel database
- Re: VLOOKUP or IF?
- new problem
- using MS Query with iSeries ODBC and special caracter
- workbook contents
- Writing if statement in excel.
- Re: VLOOKUP or IF?
- Help please ! Excel is hanging and I need to stop
- Test for #VALUE! in a cell
- $524B and $322M
- next business day
- Match and Find NOT exact value
- MS Query anyone?
- Re: lock cells after data has been entered
- smart tags
- Excel
- excel
- Re: Linking or Vlookup???
- autofilling repeated words
- Worksheet protect/unprotect
- Counting instances of a time in cells with date AND time.
- Condition is true in one cell, give me same condition in another
- Date format
- Digital ID or Signature/Approval
- Invoking Excel via command procedure line
- Closing Excel Spreadsheet in an Internet explorer window using VBA
- Deleting charts
- How can I set the end of the document?
- Replacating successive dates a week at a time?
- Re: using worksheet tab name in A1
- Type hidden text and/or numbers; return asterisks
- What is displayed in a table?
- Blank Vlookup
- automatically advance to next cell without hitting enter or tab
- & in custom footer
- excel start-up
- Re: Does the Pro and Standard versions of Office 2003 have RTD Functionality?
- Re: Does the Pro and Standard versions of Office 2003 have RTD Functionality?
- Sorting Date Problem
- Try Before You BuyTemplate
- Counting Cells
- Re: Counting Cells
- Importing Access 2.0 files (*.ldb &*.mdg) into Excel
- How to create a URL and when user clicks it to open a Excel workbook
- Convert QuattroPro with .qpw to Excell 2000
- Insertted JPG. as comment. where is the source of picture
- Header and Footer on all sheets
- highlighting rows
- How to make an excel file password protected
- How do you protect a worksheet from being viewed without having the correct password?
- Counting time instances Challenge
- Changing colum width within the same page?
- Best Add-ins!
- Concatenate range
- picture without printing
- save as change on cell detail change
- Pivot table problems
- Looking for the * in the Find function
- Saving to CD?
- Need a formula for Excel 2000..
- Referencing cells using a combo box
- Excel Problem with Width=1.00
- using the $ to lock formulas
- Combine part of text from one col to another
- Rounding a time calculation in .25 increments
- names
- Broken Link Problem - Don't Update
- Automatic Sort Updates when data changes!
- Queries
- Excel Cells Question (IS This Possible)
- round up to next whole number
- Excel - more than one instance open at once?
- print range based on cell input
- Sum by category
- how do I remove this virus?
- Excel Charts are greyed out!
- Excel Charts are greyed out!
- Decreasing font size below 8 or suggestions reducing number of spreadsheet pages to print
- assign macro
- Heading Row in a linked list
- Customising page numbers
- $ Lock cells shortcut
- Adjust the print range of a list
- page numbering
- Get one instance of each person from a large list
- CONCATENATE???
- Finding Duplicate enties & highlighting
- Combination of Minus and Equal signs
- Insert calendar into worksheets
- Is there a way to sort multiple columns with a tab or something?
- Cell referenced in Header
- including date and time in one function
- Count array cells that returned a result
- Data locked up
- Counting Cells
- Move data to list format
- Update to Flexfind
- Pasting web page that Data>Text to columns won't fix very well
- two sheets in one printout
- number to text and vice versa
- Excess white space in chart
- IF Function
- Make cursor an Arrow, not a cross
- Copy Paste Values with array formula
- Data Tracking in same workbook
- Which function for smoothing average?
- Compile Error in hidden module: Autoexec
- Using excel if function on a pricing spreadsheet
- Missing underline and Date
- Command to reference previous worksheet
- html codes in excell
- Compile errors if on computer other than dev computer
- divide by negative looking for percent
- Unique chinese fonts
- New mouse want scroll in VBA
- Copy Conundrum?
- Bids and Asks trade volumes
- Read Only Files in Mac
- Maintain 1 List... Twice
- still visible
- multi colum listbox
- Maximum number of Sheets?
- urgent help!Identifying instances
- Offset Function for Block of Data
- measerment units
- "Too many formats used"!!!
- Using Dates in Conditional Formatting
- Exporting Multi Sheets
- Macro when a font in a range changes
- Update data source in Pivot Table
- Highlight changes in all-links spreadsheet
- column width
- invisible button
- Excel will not open
- Returning the last value in a row
- Scrolling without Worksheet Shifting
- Worksheet Fornats Don't Copy
- exel colums
- Was: Re: MultiPage Tomfoolery
- look up a selection of data
- cant open a xls file in excel sheet
- Re: emailing spreadsheet
- Changing default pointer from a cross to an arrow
- Colour Pallett
- Syntax to save ActiveCell to MyActiveCell then select later
- strings with space
- Stop a file from automatically opening in Excel 2000
- can't sort in protected list even with option on
- Frank Kabel
- dates - how to get 2nd tuesday for 5 years
- Cursor color
- how to make cursor jump locked cells
- General Ledger
- Changing A Directory in Multiple Hyperlinks
- Copying Hyperlinks In Excell
- Shipbells On Time Function
- Auto Row Height problem
- Rounding up Time Values
- summing problem
- Macro in Workbook problem
- MACROS
- Vlookup error
- Named ranges, 3-D ranges, and/or arrays?
- removing characters
- Problem with Macro
- Keyboard Shortcut for...
- Need to re-add "Tools" button to Menu Bar
- Excel - Date/Time formating to text problem
- Excel - Date/Time formating to text problem
- Check 3 cells for specific content
- problem printing
- TOURNAMENT FORMS
- internet data through marco Code into excel
- embed xls file
- Transpose Address
- 45 appears as 0.45 on my screen?
- Sum(if array isn't working..
- check and replace
- Commission Structure
- Alternative to array formula to get answer?
- lookup in several cells
- Excel VBA - delete cells containing not equal
- code error - memory error
- Need formula to Check Duplicates
- How to add time values?
- Cell formating
- copying drop-down lists
- format the whole row
- Sluggish performance
- how to use VBA values in "formula=" expressions?
- Excel format display
- Current Time Formula
- Excel "Text to column" - changing data back to one cell
- Excel Problems
- Cumulative Calculation
- Lookup returning more than one column ?
- Excel Function
- Trouble referencing.
- sparkling text
- selecting several items from a drop down list
- Value containing - not Value = or Value <>
- x-axis on chart "not to scale"
- Creating a Database with Macros
- excel to outlook
- preventing duplicate entries
- VB Events (Macro triggered by format change in cell)
- Modifying cells to Print a spreadsheet
- Excell combining files
- Comboboxes
- Rounding
- selecting multiple choices from a drop down list
- Can't use paste on one worksheet
- Transfering or extracting data
- Inserting Lines
- Find Worksheet name
- auto generate emails from data stored in excel spreadsheet
- COUNTIF or SUMIF or IF
- .FileExists
- Clueless: Creating a "Score card" to track how many research harboring calls are made
- Searching Between Excel Worksheets
- max number of macros
- If Statements
- Complicated Time Formula
- Can I seperate Text and Numbers from one cell, and drop into two cells?
- Re: Sort within a subtotal
- Re: If Function Problem
- Re: If Function Problem
- Data Validation - Blank Cell
- Revision Date in Footer
- adding code to sort a list in VBA
- complicated excel template
- Excel 97
- character size in pivot table cell
- Printed Gridlines out of alignment
- Re: If Function Problem
- VBA: text same color as cell background color
- Counting Unique Values
- Entering times into an Excel spreadsheet
- Compare and delete row
- How to save each worksheet as a separate file
- Forcing a solver to write unique solutions only?
- Round
- ODBC query
- Conditional Formatting
- Refresh a read only file
- Selecting Many Non-Adjacent Rows Easily
- find and delete rows below
- format problem
- Subtraction
- Saving Excel Spreadsheets as a Web Page.
- comment indicator color
- Can'nt add column of numbers.
- Copying sheets - keeping control code
- Placing a Background in Worksheet
- Worksheet protection XP vs. earlier version
- How to copy linked documents (2 files)?
- simulating shared workbooks
- Automatic numbering
- Downside Deviation
- The number zero
- Re: Excel - Calculation problem
- Uh Oh.. gone wierd again!!
- Range of worksheets for printing.
- Turning a spreadsheet into a standalone program
- Mystery!
- help, unable to unhide?
- Formatting Cells
- Difference between Selection.Text and Shape.AlternativeText?
- joining text from multiple cells to one cell
- highlighting
- Searching a list
- Excel VBA Controls
- Accessing Macros defined in Add-In
- Separate data string into numeric and text
- Hiding rows
- dups
- Placement of Subtotals within a Spreadsheet
- Dates in Tabs
- Counting a column based on the results of 2 other columns
- Inconsitent calculations in Excel workbook
- Advance Filter not working
- Keystroke for edit
- convert the functions and formulas to values
- Formatting
- Counting dates using "more than"
- Change Color of Header Text
- vlookup
- Outlook interfering with Excel?
- Conditional worksheet function function that returns range
- Excel Dates - Comparison Operator Issue
- Re: Tab missing / reserved file
- tracking sheet
- simple one
- ExcelVBA - Macro to distinguish between numbers and dates
- Pivot Table Not Populating Correctly
- PRINTING
- Shortcut to go to previous worksheet
- Error bar
- Strange problem
- updating the data range for a pivot table
- Protect sheet
- Adding Named Formulas to a Chart
- Conditional Formatting "Formula Is"
- Text (blank) in pivot table cell
- filtering
- Simple addition
- If statement and running a command as a result of that
- Counting dates within groups
- saving attributes in Tools/Options
- Excel VBA - help with list (by using validation tool)
- Tabs
- Re: Entering data into a cell secretly
- HELP!alert when negative number comes in?
- Re: Entering data into a cell secretly
- Excel VBA - Timesheet query
- Excel VBA - Timesheet query
- Re: Printing in Letter Format
- Error message
- negative number display
- Force text that looks like currency to remain text
- Counting dates within groups
- Array formula
- Macros actioned by drop down list
- Excel column format problem, please help
- Formula answer red when should be black
- delete cell
- Find Email Address in a text file
- email addresses print in color
- Find Email Address in a text file
- Cell address
- Pricing Program and If-Then Statements
- Re: fuction to copy Column a and b to comment or colum c?
- Answer show red when should be black
- Formulas Key
- HELP! IF function..... I think!
- Print two sheets in Excel
- Deleting rows
- Using cell text in a formula
- Printing PDF's from Excel
- If formula
- copy and paste macros
- Re: Formulas
- Worksheet
- VBA Passwords
- Move Partial Data from One Column to Another
- using extracted #'s to do vlookup
- Taking text from multiple cells and adding to a different cell.
- need execel formula
- Pivot Table External Data - MS Query
- Keyboard shortcuts
- Trouble referencing, vlookup, ms query
- fixed format export
- protect macro
- Linking Excel and Word
- Spreadsheet Conversion to single page format
- More then one word replaced at same time?
- Pivot tables
- memory growing spreadsheet
- Excel Auto-refresh box gone
- Employees Needed In An Office
- need execel formula
- RE: Chinese Characters
- time tags
- Converting time formatted cells
- Re: How to type in a formula-amoratizing
- Bullet Points
- Scientific Notation
- Display a PDF file in Excel as a picture
- Re: How to type in a formula-amoratizing
- cant open excel file
- Excel Macro Filtered Visible Cells
- Excel formulas
- linking an excel workbook to an infopath form
- Re: Calculation of mean excluding target subject
- 750 KB file saves 10 times longer than a 900 KB file
- HELP!! need to get rid of last 2 #'s
- Total Years Mounths Days
- Text Box / Cell Evaluation Not Consistant
- multiple criteria SUMPRODUCT
- Custom Sort
- excel
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.