View Full Version : Microsoft Excel Misc
- Blinking Cell
- Multiple Worksheet protection
- Excel : Cursor
- Inserting contents of cell as text into formula using cell referen
- Excel Filters
- Tracking Changes Question
- Need advice/info about Excel...
- Excel 97 crashes
- Adding Comments From Cells To Chart Points.
- Printed copies numbering
- pivot tables - generating 'shortlists'
- pull down list appeared
- How to create this chart?
- Sub CountTextColors()
- SEARCH MACRO problem!!
- how to use "barcode" in excel 2000??
- Auditing
- Currency symbol inccorect
- VBA Function to convert string to formula
- Conditional Hiding of Rows
- Formula for different sheets
- PicOutput.Print => Error 438
- Sharing violation
- deleting macros
- Input Mask
- VB code to Save_as_Filename
- Excel 2000
- Printing a spred sheet
- excel file name is too long
- Freeze Panes
- Links to Cells and Screen Position
- Show date/time spreadsheet saved
- VBA macro help
- Data Table
- Combo Boxes
- How to sort info from separate worksheets on summary sheet
- Merging Files, Is This Possible
- Returning multiple values
- Changing Save As... Filename Prompt Default to CELL value
- Excel - Mail To Function. Wrong Filename??
- Using fields within string functions?
- Convert User Input into Column Heading
- Horizontal line chart - Excel get corrupted
- auto increment on new line insertion
- Grouping Dates in Pivot Table
- AutoSafe and macro recording
- Conditional Formatting
- Re: I have 2 questions concerning Excel.
- Sum Product
- Macros in Excel
- MailMerge - merge with data in Excel - arranging data vertically instead of horizontally
- automatically converting data
- Re: Formulas
- Re: Algebra Equation
- Formulas
- Command Button Stopped Working!!!!!!!
- Find/Replace text, NOT format!!!
- Re: wrapping one cell into another
- Negative numbers
- Failure to lanch Excel of Office 97
- Trendline Question- Graph with 2 Y Axis
- Combo Box - Cell Link
- Turning off date
- How to make a header a hyperlink
- data validation
- colorized coordinates
- excel 2000
- Re: How to delay the execution of formula
- read only even though its not open
- it worked!
- How to delay the execution of formula
- how do you supress the "Number stored as text" error message
- Re: VBA macro
- Re: VBA macro
- No printer but want to see the preview
- Re: Search within a string and return information?
- Re: Search within a string and return information?
- Export to Formatted Text (.prn) file truncates data
- Pivot Table question
- Opening 2000 in 97
- Guidlines for Choosing the Best Trendline
- Column Index Numbers
- File is locked for editting
- LOOKUP or IF
- unprotect sheet greyed out
- "Anchoring" one row so that it always appear in one spot?
- Condition based on Format?
- Excel windows opening up automatically.
- Excel Freezes
- Allocation of values to months
- Count Formula
- Protecting a Combo Box
- Query and Contains filter
- adding a fixed number to a list of numbers?
- File after saving is disappeared?
- CSV Files and VLOOKUP error
- Duplicate entries
- Date Displays as 1/1/1904
- Excel 2000 formula recalc problem
- Label Captions
- Printing Formulae
- Trying to list unique values in an arryay
- Hyperlinking
- calculation of cells
- Printing a List of Formulas
- Re: Change Pivot Table Data Source
- Automatically Cut Data and Paste to Different Sheet???
- Re: Formulas
- Save as Web PAge in Excel 2002
- Averge and or Maximum
- toolbar name
- Hard to describe problem
- why can't open excel?
- Tracing Precedents and Dependents - BEEP vs. Error
- Autofilter not working for cells with data validation
- msgBox Text Truncating
- sumif function
- Converting a number to Hour & Min format
- Protect Worksheet
- Automatically enter data based or start and finish times
- Pivot Table-Calculate Percentage of Parent Row Item
- Pivot Tables Rows
- ExcelReport - A Microsoft Excel format report generator
- Dates
- Advanced Filter help
- merge data from one worksheet to another
- formula help
- display arabic numbers
- Fixed field width in cells
- Change default font and size for comments?
- vba macro day 2
- Problem with sum function not adding range
- Convert Excel 97- Excel 2003
- Fixed field width in cells
- How to find the address of a cell
- Searching for text within cells
- To make the macros know about added rows
- Template wizard with data tracking
- Vlookup and IF function problem
- Excel 97 Protection
- Excel
- Non-VBA way of making custom menus.
- Data Validation Lists
- Re: Data Validation Lists
- dates and ages
- Leading Zeroes
- Counting data
- Delete Spaces
- Link 'Button' to Macro
- A Dynamic Query Worksheet?
- Re: Hyperlink to individual worksheets in same workbook
- Re: Hyperlink to individual worksheets in same workbook
- Re: Converting BOM to Excel from MS Project
- How to update absolute MDB file paths in Excel worksheet
- Re: Hyperlink to individual worksheets in same workbook
- Re: Prints pages that include unused formulas/functions
- Prints pages that include unused formulas/functions
- Calculated Field in Pivot Table
- Problem with Column widths resizing on other computers
- If Or formula
- MKBA-265103 - Anyone have a fix for this known issue?
- Re: Hyperlink to individual worksheets in same workbook
- Replace empty cell with cell on right
- Re: Formula for repeating numbers
- What are the command(s) to identify an activated VBA button?
- Average Cells with actuall numbers
- Row count
- VB Code line for determining column
- Re: Formula for repeating numbers
- creating WMF files in Excel
- listbox and combobox
- RE: HLOOKUP
- A hypertext link to an Excel documents (questions)
- Look to change font color within a cell formula
- Data - Validation - List problems
- combining like data
- linking source workbook to other spreadsheets
- cannot read file
- VB.NET to Excel
- formula question
- Excel crash involving SQL Server
- File Rights Changing
- Sumif function and negative value together
- Export results to Excel not correct
- Creating a pull down menu
- Excel Formula
- Extracting Text from a Cell
- Drop Down List Woes
- Form Control Question
- settigns for outline/grouping
- Excel Formula: Text equivalent to MODE?
- Interogating Tables
- Calculating time
- excel calculations
- Picking out the max
- Excel 2002
- MID & LEFT??
- Excel 2000: Unprotected cells - How to prevent cursor from wrapping?
- Excel 2000: Combo box cell link protection question
- Excel 2000: Unprotected cells - how to prevent cursor from wrapping ???
- HELP! remote data not accessible msg
- Email
- Re: Formula for repeating numbers
- Pivot Table Error: Cannot group that selection
- Add a FIXED MONTH and DAY with the CURRENT YEAR
- working with 2 workbooks
- Re: macro
- Filter macro / code builder help?
- Linked workbooks, how to with arrays?
- Truncation on Excel 2003
- Timer
- Importing address from Excel to Word
- Opening excel 2000 worksheets in office 97
- Convert to CSV file
- Printing Out of Macro & VBA Codes for Documentation Purposes
- Changes made to toolbars disapear when admin rights are removed from users computers
- Macro
- Deleting Rows If Not Bold
- Excel File will not open if Excel is no open first
- Code to calculate
- Columns & Rows have all flipped
- code for new rows and filling down
- Inserting a sub
- question about a code to "save as"
- Chart from Pivot table
- Multiple Search Criteria/ Index Match
- Excel Forms
- Crashing - My Excel VBA works on my Pc but not on others
- Pasting values not formulas in Excel 2002
- Running Autosum with Filters
- Problem Dragging Formulas
- Re: 免費網上"寶貝"輸入法-繁/簡 中文 廣東 / 英º~ /
- If statement help
- Locate and Move specific cells
- Comparing two rows and finding values in one row not in the other.
- Cannot use File-Open 2003
- Formula too long
- selecting rows
- selecting rows
- selecting rows
- IF AND condition
- Macro works f8, not when ran..help
- Data Table
- Excel - selecting varied length ranges for calculation
- Spreadsheet column/row design conventions
- Exort data from excel to word
- Excel - VLOOKUP Question - Urgent
- Run a macro from selecting a cell
- Significant figures
- Macro help
- Header & Footer
- Divide excel sheet into separate files.
- need help with an if statement
- Excel cell comments
- algebraic symbols
- columns to rows and rows to columns
- Preventing People from Saving
- Word Table into Excel
- How to do I change text to caps.
- send graph from excel file via email
- Re: NEW TO EXCEL
- web form
- Emailing Excel 2000 problem
- Check if a cell include number or not
- hyperlink greyed out
- transfer data without a formula in that cell
- Counting in excel
- Importing large files into Excel
- Excel Add-ins
- E-mailing from Excel
- Excel protecting formatting
- useing an existing module to extract info
- Here's an easy one........saving when populated
- Macro to hide rows
- Digital signature/certificate
- Upgrade from Excel 95 to 2002 ?
- easy and cheezy for all you geniuses
- Maximum Number of Rows?
- Question about Absolute reference formula
- Changing Formulas a simpler way?
- Hide pg1 row1 or suppress pg1 header?
- Inserting a Row from a UserForm
- Re: Excel highlights everything
- Conditional Number Formatting & Selective Summing
- HELP! sum value to be displayed in sheet 2 when data is in sheet 1
- Changing spreadsheets to .pdf
- displaying comments
- Separating last and first names in a cell
- Data-Filter on Multiple Entries in Cell
- setting custom footer in This Workbook that opens everytime (default template)
- Copy Excel to new laptop?
- Recovering old versions of saved files
- Re: Recovering old versions of saved files
- shading
- pivot table data filter
- Change the same unit in different worksheets
- Charting Dates on X axis
- Text formatting in cells
- Continuous Line
- metric picture resizing?
- Turning off exponential notation
- Re: Unavailable
- checkbox
- print problem
- Re: Setup Timesheet in Excel
- Pivot Table - deselecting multiple items quickly
- Excel installation
- Drop down field
- Date/Time Array Problem
- Excel version compatibility problem?
- External References
- Selling Excel Spreadsheets
- Re: Data Filter results no longer show # of records in filtered list
- Excel 2000 - Missing row heading, but have column heading
- Displaying Watermark behind Graph lines - Excel 2000
- Re: NEW TO EXCEL
- Linked Excel table - font color not printing in Word
- Re: Data Filter results no longer show # of records in filtered list
- why is my machine running slower?
- How to specify tab through ranges
- Disabling Save As
- Specifying next cell to "jump" to
- duplicates
- Finding data in grouped sheets
- current time on excel
- require cell entry
- Worksheet Problem - Need all sheets to populate one
- linking files
- Populating a ListBox
- Re: PivotTable: Getting Rid of Sub-Totals
- how to find relative posiition of first and last non-blank cell in a range?
- URGENT:Concatenating 1000 cells into 1
- Workbook is taking 2 - 3 minutes to save. Please help
- Sumif formulas creating large files and significantly increasing save time
- stand-alones
- Layout of table
- Re: different workbook
- Re: Feedback on new format
- Indirect cell reference
- find question
- Progress bar for Pivot table
- displaying info when part of a graph is clicked
- getting data into columns
- Posting an ACTUAL sheet
- Excel VBA CPU Usage
- Check box size
- opened Excel w/sheet from email attachment, updated, saved & cant
- Extracting hyperlinks
- How Do I do a simple mail merge?
- How to Reduce Memory requirement of large Excel workbooks ?
- disable select multiple items in pivot table
- Last Day of a Week based on NOW()
- Using 'find' when workbook pages are grouped together?
- Help,
- Moving data without a formula
- Leading '0's disappear after transfer by macro
- Text Box
- Search whole workbook
- looking for advice
- Individual keystroke as a separate entry?
- Military time viewed as civilian time
- Excel Edit - Copying problem!
- Convert Date to Text?
- Autofill of cells after a lookup?
- File In Use - Message
- summing question
- Using Backgrounds in Worksheets
- Excel's Advanced Filter unreliable?
- access denied
- Naming ranges
- Disabling Save Button
- how to completely remove hyperlink
- how to generate a series with a suffix?
- Sorting data based on quarters of the year
- Truly null value
- 2nd ORDER BY in form fields
- sumproduct
- Transforming sheet1 rows into a single sheet2 col
- Re: Excel Viewer for Windows XP
- Freeze Column Width?
- reference to future worksheets
- "FILES OF TYPE"
- Choosing info from one column based on another column
- Help required: Automatically completing a list
- HELP - Data Analysis
- Identifying Cell Colours
- formula reqd.
- Questionnaire
- formulas changing when emailed
- Re: Book1 in Excel
- Cell Protection
- Automatic Comments Boxes
- Show value, not formula in formula bar
- migrate from Lotus 123 - roundup doesn't convert
- How to merge databases
- Date conversions....Excel thinking too hard?
- AutoFilter and Frequency Function
- AutoFilter and Frequency Function
- possible to default?: Format Comment > Alignment > Automatic Size
- Re: how do I do a "starts with" - search & replace in excel
- Start a Subroutine from a link ?
- Formatting text in a Comment
- Re: how do I do a "starts with" - search & replace in excel
- Re: Percent Difference
- vba hiding a workbook
- Imported dates have month first.
- Re: Percent Difference
- File Sharing
- Deleting HTML form elements from worksheet
- Question on Linefeeds and Carriage returns...
- Nested formula (I think?)
- How to write a VBA code to select certain rows based on certain conditions
- more than 3 conditional formats
- Re: Excel Add-In for SQL Analysis Services 2000
- Is there a easier way to do this?
- Re: Percent Difference
- disappearing menu bar
- MASS EMAIL
- Excel form web print
- Simple Date Formula
- Re: Command Button Code
- Keeping one of 2 cells always zero
- windows in taskbar and windows 2000
- Format Cells based on 1 or 2 Cell(s)
- Customized Toolbars
- Networkdays in Excel 2000
- workbook names followed by a colon then a number
- VLOOKUP issue
- locking cell format only
- Sorting out Duplicates
- How to Match a neg with a pos. number
- Excel 2000 STILL hangs on sort
- Macros not recording properly
- Hide row and column labels
- Macro e planilhas protegidas
- Save a workboak with Commas and double quotes
- Format cells with inserted text
- Macros and Virus scanner
- avoiding debug error
- Adding zero's to the beginning of a number
- embedding and displaying an image in CSV created spreadsheet?
- Excel Date Format
- Change the default value for F11
- rs232 com
- Network save error... The file may have been changed by another user...
- vlook in forms
- Hide rows in a calculated field in a pivot table (Excel XP)
- open to a specific worksheet in a workbook
- DBCS chars garbled in downloaded CSV file
- Counting UNIQUE occurrences within a range
- Bold in Formula
- Importing across Excel files, and using MSQuery?
- Pivot table labels
- Re: merging data from one worksheet to another
- insert column problem
- Re: Opening JPeg file assoicated with an Hyperlink
- Matching Cells
- Security in Document Control
- Macro help to position a freeze pane command
- Macro help with saving a spreadsheet with date and time in it
- sort dates
- Improving the looks of basic sheets
- including blanks or text values in macro-entered formulas
- Formula help required
- Date counting again
- Drop down arrow location for validated data
- UserForm Labels "0" return
- Remotly Launch Excel Worksheet
- Convert a worksheet to a text delimited file
- Update to the Name Manager
- recover overwritten file
- restoring an old excel file
- Large scale engineering calucations performance bottlenecks
- Column/Row reference errors
- Selecting a cell based on counting visible cells from the top
- Shut down PC and Didn't save excel Doc, can it be recovered
- Relative reference and macros
- Looking for more trendline regression functions
- Formatting entries in userform textbox
- Graph Printing Problem
- Excel 2003 Addin "Template Wizard with Data Tracking"
- Execute macro to run automatically
- Multiline SQL Query Error in Excel
- Changing from ALL CAPS
- text-to-speech with different languages
- Mileage tracking
- Merging Cells
- FORMAT CELLS
- Formula Help
- Print the user name
- Dollar sign
- Re: Hiding Personal.xls file on start up
- Copy / Paste Merged Cells
- Re: Formating a cell
- Re: convert txt file to excel?
- Re: convert txt file to excel?
- Re: Hiding Personal.xls file on start up
- Data Table Problem; DGET? may be solution
- excel problems...
- Creating a header/footer with a link to spreadsheet data
- changing from euro to dollar sign - ctrl+SHIFT+$
- Help with Sales Totals
- Trendline Graphs
- Pivot Tables w/ blanks
- RE: VB command to move down one row
- Lists of Numbers
- RE: Custom number format
- Re: Custom number format
- Linking
- Chainge cell values to formuals
- Macro Question
- Text is too long Error
- Combining Times and digits
- Automatically sorting names alphabetically.
- Custom toolbars and shared drive
- Database trouble -- please, please help
- Read-Only
- Is there an Excel Developers Extensions Toolkit
- Help please - excel virus
- Adding a coma to the text data in every row of a column
- Re: visual basic command to move down one row
- Eliminating duplicate records in consecutive rows of a column
- Re: Active Checkbox
- Re: Option Base 1
- Re: Search a Variable
- How to resize background
- Re: Multiple Hyperlinks in one cell
- Re: Personal.xls workbook locked
- Re: Change data from column to row format
- Help plse!
- Re: Option Base 1
- Re: Extract dates from table in word and converts to american date for
- Date formatting without my telling it to - can't undo.
- Re: Data to Text
- Re: Counting unique entries of numbers and text
- Re: Pivot Table Overload
- Excel 2000 date does not display date correctly
- Help on import csv to excel
- MINVERSE
- Find in Excel 2000
- Number Separator
- handling xml "list of lists" in excel 2003
- link to sheet
- insert Object from Excel into Word
- start excel and decimal point
- importing from laptop to desktop
- How to enter a moon phase series into Excel??
- Windows 98 and Excel
- checking for existance of file before running macro
- Trendline Question- Graph with 2 Y Axis
- Variable name range
- Trendline Question- Graph with TWO Y Axis???
- Transferring info between Excel sheets ??? I'm stumped......!!
- Please help
- Excel print question
- How do I keep a button size the same!
- MOUS - Pivot Tables..I'm never going to get it
- Macro to save file using vlookup...
- can I creat a series with .jpg suffix?
- Saving from website demo
- countif and sum for arrays
- Changing the color of a command box
- Help eith macro and command function
- cell with only a single quote
- Is it possible to disassemble text? (i.e. if Cell A1="AR-01", can I separate the AR?
- Is there a better way to write this code...
- Nested Function Calls
- Re: Is it possible to disassemble text? (i.e. if Cell A1="AR-01", can I separate the AR?
- Questions about shading and gridlines
- How to "Fill Down" Until Infinity?
- Question about pasting from the Internet
- previous information is not saving
- Syntax
- vba module password recovery
- New Scroll Bar
- Retrieving Count of rows returned from MS Access Query
- Printing Columns
- Excel formula needed or how to
- Problem with row and column desgination
- Mark Cells for input data
- Formula Syntax - What it means?
- Where have all the windows gone?
- Column Numbering
- Dropdown menu on input box in dialog box
- Problem with sorting
- 2 differenct decimal options for same cell results
- Cell Auto Advance
- Comment edit, fails to exit
- fairly basic excel question (i hope)
- break a text string and export to cell range
- macro recording help
- reference to closed workbook
- Linking drop down menus in several pivot tables
- Creating macro for find and replace
- Save as Web Page for Excel 2000
- Auto open Data-Form option
- Re: Compare chart
- Custom lists from different sheets
- drop down selections
- Word wrap in drop down lists
- Excel workbook and sheet damaged
- Excel 97 crashes
- PRINTING ERROR
- Excel 97 crashes ?!?
- Tax calculator - I am really stuck!
- application.run cant find open file
- Excel - dynamic ODBC query to a sybase DB
- Double vlookup
- Adding zero's to the beginning of a number
- Double vlookup
- Versions?
- 97 vs 97 SR-2
- Excel - changing dates from AM to PM
- Automatic Order Number
- Calculate the difference between two times (excel in office xp)
- Changing individual characters in a cell to a different character
- Strange......
- Removing blank rows
- Excel 98 Mac - files open under imovie
- Re: numbers entered in cells are suddenly changing to 0.0x
- Re: numbers entered in cells are suddenly changing to 0.0x
- Excel 97 out of memory
- excel problem
- Fantasy Football Draft
- Re: Formula
- MS09.dll error
- Re: Column reversal
- Re: Column reversal
- Problem with Merging Data Cells with Empty Cells
- Excel Menu Textboxes
- updating macros
- Excel 2000 crushed
- 1 file multiple worksheets
- Cannot empty the clipboard
- Something does not work
- Launching Excel Using .bat file
- Excel Formulas
- Formula vs Constant
- Formula problem
- drop down menus, how to get full view
- wordart
- Problem with deleting macro
- Custom AutoFiltering
- Essai
- Macro help please: Excel data to word doc
- pop-up/comment of text in chart
- Re: Compare two columns and find Diff.
- Column widths
- tiled worksheets
- Excel Date & Time values problem
- How to create a digital certificate...
- Re: Inserting a Symbol in Excel 2000
- FTP from Excel
- Linked Spreadsheets Problems
- Sorting more than 3 pieces of data??
- Re: Creating an Object
- Re: Only enter in certain cells, save, and distribute
- Only enter in certain cells, save, and distribute
- personal.xls
- What's causing this error message?
- pulling a hard return from a cell
- Re: Compare two columns and find Diff.
- Only enter in certain cells, save, and distribute
- Variable in text field
- "Save changes" question.
- Duplicate Numbers
- Auto-wrap after copy/paste and Merging
- Re: pulling a hard return from a cell
- Book1 issues
- Max if???
- Excel question - formula design
- SUMIF Question
- Set Print Area
- Re: Formula
- sorting by number
- sorting by number
- Separate Workbook windows
- Square Character in Excel (apostrophe)
- Pipe Delimitation
- Comparing and contrasting columns
- Re: Inserting a Symbol in Excel 2000
- macro visibility in auto loaded macro sheets?
- "Not enough system resources to display properly"...so now what?
- Date filling down
- Q: how do i enter % in the formula?
- mozilla
- Pictures in Black and White
- microsoft Excel 2003 always hang up
- Vlookup Function
- ScrollArea
- Infuriating AutoCorrect problem -any ideas?
- Concatenate text & number cell
- Printing Autonumber
- Automated Excel, Fill from other file & save (html)
- Unlocked cell formatting
- Countif with upper and lower case
- Wroksheet is grey
- Saving to a UNC path in excel 2003
- Incomplete Calculation
- Lookup with offset
- function to check for entry
- new window
- Incorrectly scaled graphics
- Capex - IRR; Cash Flow; Payback
- problem Regarding to the Transalation function of office xp
- Linking Combo boxes to one another
- Comment in Excel
- Pasting a value into multiple cell addresses
- Splitting Text in a Cell
- Restore button
- Excel saving random files
- ClearContents with condition
- Sorting blank rows in Excel
- Re: Displaying 2 worksheets from the same workbook file
- view, task pane
- Unwanted Internet Access
- Protecting a worksheet
- PASTE SPECIAL - Paste Values vs Paste Unicode
- Numbers getting cut off
- File size(shared workbook)-huge increases on save.
- save as web page
- Restrict Data Entry in Combo Box
- Multiple sheets sharing variable data
- Time Sheet to Outlook Help possibly!
- Double-sided printing problem
- Dynamic Data Exchange (DDE)
- Unique Rows
- print macro to solve limit on page breaks
- print macro to solve limit on page breaks
- Re: Automatic Comments Boxes
- Check Box Formatting
- Date/time code, both, accesible by one keystroke?
- Error message.
- word "calculate" will not go away
- 13-Month Report -> Changing months
- Re: DeleteFolder
- list links in new worksheet
- Re: horizontal data to vertical data
- Posting date on worksheet
- Commenting on comments
- Combining Text with Formula
- Probably very easy question conerning auto-changing dates
- Exporting data from Excel to Word
- getpivotdata excel97 compatability with later versions
- Excel does open like it use to...
- Inconsistent run-time error
- saving worksheets as individual files
- copying & pivot tables
- Max If???
- Macro to sort a predefined list
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.