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