View Full Version : Microsoft Excel Misc
- Redifining cell
- Pivot Tables
- Percentages
- Hyperlinks
- Issues
- ActiveX button Hyperlink only works in design mode
- Client Authentication request
- Filename
- strange behavor for send to
- Excel 2003 - sheets all coming up protected and Read Only
- Read only for all other users besides myself
- information within a cell
- On Event
- Unique Column in Excel 2002
- Excel 2000 hyperlink problem
- Footer - page numbering
- Date Format Issue
- Duplicate files - different sizes?
- displaying x number of rows on top
- count number of sheets in workbook
- Filter, copy, paste on same sheet
- (Semi-)Automatic cell selection for calculations
- Duplicate Names by factor of 4
- SUMIF function - multiple criteria
- Excel 2003 in Acrobat
- Why does a sum formula display 6.66134E15?
- Customize Menu
- Run-time error '1004': Programmatic access to VB is not trusted
- Macro Error
- Pasting to Rows with with text only
- Consolication of data
- Creating a Survey in Excel/Word
- Template Wizard with Data Tracking 2003
- Control Toolbar Button Caption
- Excel Issue - Return a zero unless all blanks are filled in.
- default font size for comments
- Sort fail
- Show a sheet1 row in sheet2 based on values in col sheet1.A
- Help needed, please - tables to piechart
- Password the VB Editor
- Re: SOMEBODY HELP ME PLEASE
- Units
- Units
- Calculated measure problem (OLAP) in Excel Spreadsheet
- Can't format cell with border
- Simple Checkbox
- Date Formats
- Can you undo a save?
- How do you change automatic color?
- help with max, min, <, > in array functions
- Track changes to cell formats
- Formulae Help Please
- link lines (lineas guia in Spanish)
- 2 Macro Questions
- formulas
- Formula via Offset() exact not relative
- Filter based on formatting
- What's a Road Limit?
- Ctrl + End takes me to no data
- Advanced find and replace?
- Excel query
- turning off sounds
- Is it possible? 3 level validation list
- Print Ranges
- Naming the columns
- Multiple arguments using the COUNTIF function
- Excel
- help me
- Cell boarders
- Coloring Emails : OL2000
- sorry ~ POSTED IN WRONG NG
- Short cut for return in a cell
- linking worksheets
- Not exactly sure
- formulares
- drop down menu's on every row of a column
- Microsoft Visual Basic - File not found [PLEASE HELP!!]
- Multiplying two columns
- Tab orders
- How to get rid of #VALUE! ?
- assign code to control object in run time VBA
- squashed columns
- Missing Vertical Grid Lines
- mailmerging multiple datasheets
- Reduce the size of a sheet with empty space
- Is it possible to replace a button with something else?
- How to play games in excel?
- How to get rid of spaces only in empty cells?
- Is it possible to do conditional column/row hiding?
- Jaws printing
- Converting QuatroPro to Excel
- EXCEL ERROR
- Pasting Links
- Adding Animation to a Chart
- Pasting numbers doesn't format them as numbers
- macro not working right
- Find duplicate cells
- automatically saving as sheets instead of workbooks
- text within a cell
- Is it possible to display autoshapes based on conditions?
- Letter format drop-down list (Data Validation)
- I need some help with macros
- Bold and fonts
- HELP. Need to extract data from corupt file
- Help Required with Macro to Manipulate Data
- how do you convert formulas to just plain test?
- preventing a workbook being changed? (not as simple as it sounds!)
- Converting comments to cells
- macros
- Check Box Properties
- More than 3 Conditional Formats
- How do I get the Count numbers to automatically appear in Bold?
- Workbook names as text in cells
- Excel2002 vs. Excel97
- how do you formula's but leave the value.
- Installing Excel Add-In's for all Windows users
- Protecting cells & formatting
- Please help me: Refresh pivot table using another source file.
- Can't Assign Macro (not grayed out but nothing happens)
- Protecting multiple sheets
- How to change Network Diagram Box Size (MS Proj 2000)
- auto open summary property dialog box
- If Then Statements....
- Need to change data entered into cell. HELP ASAP!!
- Excel 2000 Templates in Excel 2003
- Re: scenarios
- Converting one column into two
- Formatting Cells to Show Numbers as Degrees?
- Converting 123 to Excel
- Percentage-difference
- Paper Size
- Network File lock not detected
- can't format for leading zeros
- Saving toolbar changes
- mail merge equivalent for an Excel form.
- Caculating A.P.R.
- Copying data from the web
- If statements that look for a date range
- Office XP Excell
- Macro/message box to prompt user for their name and save name to cell
- Excel 2000- protect one column- can only be modified by one person
- Convert a formula into text
- Bloated workbook
- Excel on my web site
- automate fill handle process
- have excel list the results
- How to refer to columns in repeating groups
- How do I get a combo box to list my selections?
- Excel 97 Registry Keys
- converting text into formulas
- Truncating numbers
- Sort Order vs Comparison Order
- finding max amounts
- Comparing two columns of data and Highlighting the Differences
- Function to return Oracle result
- comments in protected sheet
- Text Box Tool Greyed Out
- cells
- Help: I am trying to create buttons in Excel
- Searching for Excel files that have been Shared
- with not print bold print
- Autofill on Formula Not Working - blowing my mind
- How to send a self installing .xla within a .xls workbook application
- Setting Combobox Values
- Protect a worksheet/cells from being copied
- Can't select a range after moving a shape object
- Left justify across cells with word-wrap without merge
- Document not saved problem
- Prints extra page-nothing on it
- How to create and use xlw file? Help!
- Percentage of the Whole
- when excel opens
- hit counter question
- More on xlw file and auto-update among xls files
- multiple results search
- Yes/No Display
- Link Updating Program Needed
- Counting text characters in a row
- Failure to save a "shared" workbook
- internal margin around text in a cell
- Should an XLA for Windows Excel work on Mac Excel?
- Registration Mechanism for Excel Spreadsheets?
- Too many cell formats
- Save as CSV
- MS Excel creating inventory
- How to write a small file to the disk using VBA5?
- Borders
- Clear the content of a cell
- Dynamic Name Ranges in data validation
- Saving an excel generated .htm files as an excel file
- sumif and the if formula problems
- V-lookup
- AutoSave Function timer
- how to replace a date with new date
- how to replace the date
- very urgent
- Tab Order
- Printer dropping off
- Embedding spin button
- i need your help
- stopping of program in VBA
- linking sheets
- Scientific Notation in Text Cell after Fill
- Tab key doesn't move cell by cell
- Dynamic Range Names - 2 Qs
- Control Box help - visual basic
- Can't see any cells in Excell
- calculate
- Displaying Date Saved
- VBA Issue - Request and approval via e-mail
- EXCEL HELP!!
- Excel Function help needed please!
- Unknown data in cell when number entered
- Header problem
- hierarchy problem with minus sign in front of parentheses =-(1)^2
- Is it possible to change the colour of a cell?
- filling numbers
- Excel save problems
- Limit on number of users for a shared workbook?
- How do I break a chart data range
- Personal Macro Workbook xls
- Do not allow formulas in cell
- Excel - Populating blank columns
- work sheet names
- Data Validation Problem
- excel2000- modify msgbox
- monospaced (fixed-width) fonts
- Limit No of Colums
- Excel Desktop Links malfunctioning
- Excel Limitiations When to change to database
- My columns are numbers too!!!
- Grouping a Series Of Rows
- excel changed the precision of my data in .csv
- Cell = Formula Bar
- Locked For Editing
- Re: Excel 2003 compatibility with 2002
- Re: Excel 2003 compatibility with 2002
- sumif question
- Customizing the Toolbar
- Re: card suit symbols inserted in excell cells
- Re: card suit symbols inserted in excell cells
- recovery?
- Re: Spacing between rows
- Pivot table
- setting inches in MS Excel
- Sharing excel info
- Copying contents CSV-XLS
- Importing external data based on value in Excel column
- Re: Put Default Value in Empty Field
- lost menu option on excel 2002
- Text change in field/ Macro Help.
- Re: Repeating Lines in Page Setup
- Re: Put Default Value in Empty Field
- Repeating Lines in Page Setup
- Excel / Access shared file update
- Special fractions
- Link update window opens on opening a linked Excel file
- sumproduct
- close w/o saving
- ICT Project: Vlookup and dropdown box
- Saving Formulas
- print area changing size
- Gridlines missing onscreen in worksheets saved in XLW extension and from QuattroPro
- Could not reestablish DDE connection
- RE: card suit symbols inserted in excell cells
- neededing to make text pivot table if possible
- Option buttons
- Need help with formula
- Print preview distorts objects
- ???
- Row > Height > Autofit messed up
- Cell references
- Increase font size in pull down menu
- remove dublicate rows
- Overtime past 8, 12 and 40 for the week
- Hide A row based on a value in that row?
- Clear the content of a cell using VBA
- RE: Remove apostrophe's from worksheet
- excel won't open file
- Re: Generating sum of multiple random pages
- Concatenate problem
- Strange Occurance Viewing less than 40%??
- Re: Remove apostrophe's from worksheet
- Selecting cells with text and placing them in a column
- Date format problem
- files wont open
- Empty Cells Causing Huge File Size
- binder
- Format "unlocked" cells in a protected sheet
- Excel Viewer
- AutoRecover in Excel 2002
- vlookup help
- combo box printing
- Need old version of Excel.
- Save file as information in cells
- Selecting only odd numbered rows
- excel 2000 and mail prompt
- Printer Settings do not change
- birth day in advance
- Excel Problem Cuased by MyDoom.f
- microsoft works
- microsoft works
- FWD: Taste this important patch from the MS Corp.
- COUNTIF query
- Sort order - Excel and Explorer
- VBA to open all xls file and...
- how to restrict the old number already entered
- Weird Save Problem
- Cell To Be Filename
- Pivot table : bulk field selection
- Is it possible to set an alarm in EXCEL?
- How to subtract some rows from a range
- CHECK BOX
- Is it possible for a GIF to work in Excel? If so how?
- If formula problem
- determining time differences
- Rows numbers missing - not hide/unhide problem
- executing a stored procedure on MS SQL Server 2000 within MS Excel 2000
- Macro Question
- Print preview-hide dotted lines.
- I can't make it do mail merge!
- This should be simple....
- De-Duplication
- convert to ms access add-ins
- Excel's Clipboard
- Smart Tags for stocks - some missing
- Inserting auto weekly dates
- Get workbook version
- Copy Cells
- excel help
- Re: Inserting Auto "weekly" dates
- Re: Custom Sorts
- Re: Custom Sorts
- Re: Inserting Auto "weekly" dates
- Custom Sorts
- Adding & Naming Worksheets in a macro
- Default format settings
- Autofit Row Height
- 2 statements for one if
- Excel not working correctly
- Opening XLS files directly
- cannot empty the clipboard
- combining cells
- Initial WorkBook Name
- Gross Margin Formulas
- Golf Handicap
- Alarm Sound Function Not Working_Any DDE Gurus??
- Inserting a jpg in a comment box
- Display Auto-Filter Condition
- Excel 97 - Trying to compress data by clicking on + and -
- EXCEL VLOOKUP or MATCH fx Problem
- Too much text in one cell
- Backgrounds in EXCEL
- Microsoft Query criteria syntax for date() or today()
- if- then question
- Exporting To Excel With ASP - Number Problem
- Cell Refrencing Problems
- calculating years months days hours minutes and seconds
- excel 2000
- VLOOKUP and matching TIME
- Password protection/validation in excel 2000
- another if-then question
- Add a number to the current cell
- Protect Contents, but Not Format
- excel ms09.dll error
- linking spreadsheets to each other
- Excel Organizational Chart
- Re: card suit symbols inserted in excell cells
- copy level 2 data in an outline
- Truncating decimal places
- Linking Comments
- HELP!
- change the default font for Comment
- disabling combobox with VBA
- Converting a text time into a time format.
- Can I call a macro from an if statement
- I need a help
- kicking off a prompt box requiring input when any cell in column C is keyed in
- Relative Sheet References
- Quicktime TIFF Viewer
- Shared Workbook Limitations
- extended text box cell link
- A Conditional Macro
- need macro help
- Count
- hiding data
- Due Date
- How to Stop Worksheet_Change event from running during code execution
- Calculating Area of a Triangle in Excel?
- 2 textbox questions
- Excel 1900 Date Problem
- Breaking up a procedure into modules
- How to Edit a range?
- Data from more than one cell on one worksheet into a single cell
- adding a constant to all values in a column
- Table Data on Chart.
- how to add only positive number
- Conditional Formatting & Find/Replace
- Retrieving data from another workbook (path?)
- Slight change now macro error
- Average occurance in a day?
- Hyperlink
- Help identifying a function
- Merging 3 sheets based on one variable
- Opening Lotus 123 Files
- Lotus 123 Files
- excel
- How to keep the macro running?
- RE: card suit symbols inserted in excell cells
- Traking all combinations
- multiple countblank
- Excel Print Preview
- Date Format
- Formulae Help
- Data Validation List Additions
- Charts not working after pasting table from html page
- Is there any ADOBE ACROBAT expert in here?
- Is there a way to adjust the freeze pane size?
- Value
- How do you link to a worksheet of a web posted spreadsheet
- opening XLS files
- Counting Occurrences of data in cells
- Gridlines on print job - please help
- Sorting to alternate worksheets from master worksheet
- Vioce reminder of what I have typed
- Can Excel do this?
- Increase Zoom in Print Preview
- Linking two excel files
- Hiding formula
- Julian dates
- Text Values
- Performed Illegal operation
- format of numbers in a downloaed file
- Hiding A Sheet Command Button With VBA
- Changing Color of Worksheet Tab
- What can be in cell but not Print?
- Show Last Matched Value in Column
- Insert Specific text into fields
- Graphic features of EXCEL..........
- What is the formula to count cells with specific text
- HTML and realtime webservices used with Excel
- excel name formula?
- vlookup help
- Multiple IF Scenario
- How to add a new line inside a (text-formatted) cell?
- Ranking 1st - 10th place
- IF Formulas
- Print column A on each page
- Summarising lists
- How to display inserted pictures with conditions?
- How to Call Macros to Activate once a cell's value has changed?
- Copying CSV-XLS, large amounts-different folders
- Ungroup a pivot table in XL 2000
- help with commissions calculations
- PRINT LONG ROWS
- Limiting the viewed area?
- Superscript in chart's x-axis
- Excel comparative query
- Help Request: Links
- Missing border in print preview and also hard copy
- Alowing for the Absence of Data from Multiple cells?
- VLOOKUP and RAND question
- Can't record a Macro
- VBA shortcut
- Functions
- printing w excel
- Summing every 12 rows
- Excel - reference to cell
- Where would you write an "Open Workbook sub"?
- Using a Message Box to display ‘Random Quotation’ stored in cells
- display of calculation result is wrong
- How do you link shared spreadsheets and reference certain cells
- Count the cels with the same collor made with conditional formatting!
- Macro which will allow user to searchfor whatever he wants
- Data requires decimal point problem. Pls help.
- Grouping Pivot Table Data
- Simple questions?
- Why have cell lines gone away?
- Excel - Efficient 4 table procedure
- Getting a macro to run a formula in a cell?
- Setting the Tab index in a worksheet?
- Excel Macros in 2000 copy to 2003
- gross margin formula??
- The Old Man and the C: prompt
- Displaying Tab Name in Cell
- Displaying Headers and Footers on Screen?
- Font color
- Excel Templetes?
- Excel 97 Autoback
- Pie Chart Macro
- something's wrong
- vlookup range
- Need totals for same items
- print out formula
- Adding Hours and minutes
- restricting user entering the value
- scenario manager
- Macro to create hyperlink
- Excel 2003 Language
- The & character in the footer
- Locking a row
- Links lost in XP but not in 2000?
- Range in VBA
- Inserting special characters
- Difference in hours between dates.
- Saving as a Template
- find related products
- Negative saldo when comparing hours
- spinner copy
- identifying same or related products (franks results and what I need for results
- Printing divided windows in Excel?
- Percentage Calculations
- Sum of selected items in status bar - putting this on the clipboard
- Data Validation Pivot Table
- Automated copy of a block of cells
- Hidden Sheets
- Checkbox Title Font
- scroll limits
- Matching
- Error When Inserting Rows
- Templates / Workbooks for the Construction Industry
- How to apply a constant throughout a worksheet
- Help on excel worksheet linked to access table and form
- Re: email
- Re: email
- naming columns (not row specific)
- Micosoft masked edit control
- Taskbar
- Automatically opens files
- inserting current short date into an Excel document
- Web lookup
- pasting to comments using a macro
- Character Map Shortcuts, How To
- Text Formatted Columns show as XXXXXXX
- Re: If Formula
- Re: If Formula
- Re: If Formula
- runtime error 1004 can anybody help me ?
- Move row of information to bottom of worksheet
- Email Excel as Attachment Question
- Excel 2000-VBA-exact match 3 columns in 1 row to rest of sheet.
- Sorting
- macro touble
- Lost in the post !!
- Re: auto save
- missing scroll bars
- Re: Excell 97
- excell install
- excel formatting defaults..
- Shell Print doesn't print all pages
- Twist on Freeze Pane
- run-time error 91
- Figuring amount of time elapsed
- TAB Keyboard Button
- only sum on visible columns
- Opening excel files
- Quattro Pro
- Opening a .qpw file in excel
- Comparing Microsoft Excel 2000 and 2002
- How can I make a formula to take text from multiple cells and put it all in one cell?
- Autofilter: save contents of dropdown box?
- I think I am in need of a Macro for this?
- Saving large text field so it 'pops up'
- Jumping Between Cells
- Re: Move Information with Matching date to Another Worksheet
- Stack Bar Charts and Data Labels
- Conditioning Format Question!
- Sports timing in 1/100 sec
- Grouped worksheets do not show up
- Drawing accuracy in Excel
- more columns?
- Automate Cell colors??
- Excel pauses when I use the bold cell feature
- summing rows with different criterias...
- Control Form??
- Excel File Size
- Sorting Columns By month
- Help creating a summary table
- Sum function with Insert row ???
- copy pasting data
- copy pasting data
- Custom Header caracter problem
- Help Me
- Oh My Gosh !!
- Dynamic chart
- Count Hour differences between two specific times
- Separating Text And Numbers
- Do not Print Selected Cell Values
- cash flows
- importing html tables into Excel 2000
- Group identical cells
- used range after clearing cells
- Anyone willing to help with changes to my work spreadsheet?
- Automatic Save on exit
- Formula displays Zeros
- drop down list
- Custom Formatting/Data Validation
- sum time
- separating data from within a cell
- Dynamic name range/pivot table
- Combining ISNA and LEN functions
- including formulas in inserted columns
- disk full error in excel
- text wrapping is not proper for more than 255 characters
- Scrolling of columns
- Copy time as text
- Logical suming rules
- problems associated with shared workbooks
- help me for dropdown list
- date roblems in pivottable
- Corrupt Comments
- Goalseek, with Application.Calculation = xlCalculationManual, always updates all open worksheets, can I disable this?
- changing data format from DD:hh:mm:ss to hours
- history of excel use
- How do I "break" Links?
- Family tree
- Web sites to get currency exchange rates & upload it automatically
- How to download a HTML table from a Web site into Excel
- VLookup with Multiple Answers
- Spreadsheet Audit Software
- Data Validation
- column title
- invoice
- "001234" in CSV becomes "1234" in XLS
- Paste a function to another cell
- Unlock file
- Excel Functions
- Lookup
- Hyperlinks from control buttons
- pivot table parameters
- custom cell format
- XML files
- embedded word document in excel won't accept text
- Converting time (over 24 hours) to decimal
- How can I get multiple columns of data formatted into a single row? (simple macro?)
- data tracking in Excel 2003
- Silly text/cell color format question
- Re: runtime error 1004 can anybody help me
- Formula or Template for Vacation Schedules
- Visual Basic Problem in Excel 2000
- Novell - Office XP Wrong Drive Selected when Save As on Novell Network
- Urgent: Help with Pivot Tables
- Formula Calculation Problems
- How to stop excel from opening all the spreadsheets on C:
- Macros, Tab Index & the Name Cell
- SUMPRODUCT Issue
- change row color based on value in cell
- Fully expanded excel menus
- Calculation Problems - Redux
- Residual Data from Pivot tables. Excel 2000
- Allowing for more than 15 digits when downloading from another source
- Accessing Worksheet Properties
- Macro stopped working
- changing case in excel
- MS Query
- Find in multiple worksheets
- Run a macro from within another macro
- Macro - making another window active
- display last filled field of a column as total
- Combi Box Links
- Can't record a macro
- shadow effect on cell
- vlookup
- How to Combine Data in Several Columns?
- How to Combine Data in Several Columns? (How it should look like in the end?)
- making vertical data horizontal?
- URGENT: Populating combo box with data problem
- error message when opening excel file
- Adding on data automatically
- Cannot password protect
- Deleting cells in multiple worksheets
- # of Macros ... What is max limit?
- rolling calculating formula?
- Maximum number of decimals used in calculations
- can excel calculate positions basing on values?
- Excel VBA - Userform combox problem
- Excel slow to scroll
- Protect Workbook
- VBA/Macro
- Inactive close button
- Re: change number to text
- Calculate monthly paiements
- Re: trying to PDF Excel file that contains check boxes--not working!
- problem skipping columns
- Re: Conditional Formatting Not Showing..
- RE: Conditional Formatting Not Showing..
- Problem opening xls files by double-clicking
- Texture files
- convertions
- Movement of mouse selects more cells.
- Personal.xls opening on start
- Subscript out of range
- Excel: Combining several columns of Dates & Currencies
- where is the select all button?
- mysterious red line
- Can't open attached excel file from e-mail
- Header/Footer
- Excel 2000 sorting by date problem
- Date comparison problem
- Embedded Charts & Macros?
- displaying worksheet tabs in two rows?
- Cell pointer
- Expanding columns automatically
- Re: How do you format the date using the NOW function
- Fundraiser database
- Re: How do you format the date using the NOW function
- Textures Files ... more info needed
- Excel opens excel workbook called PERSONAL
- External Dynamic Named Range as pivot table source
- Using named ranges in data merge documents
- Re: Filter - Auto Filter
- spell checking a protected form
- Problem with Excel 2000 and CSS
- Pivot Table Label vs Orignal Data Column Name
- Basic question for a beginner
- Custom Formatting
- sorting by last name
- Updating Links
- Problem with Excel 2000 and CSS
- warning in hyperlink
- chart properties
- #######
- selectable check boxes
- sorting
- Excel newsgoup statistics for February 2002 are now available
- Can I print an excel sheet and skip empty rows
- Help with sheets.add
- MAX, MIN without "0"
- I need to exclude a value from a list based on a corresponding value.
- how to calculate time diffrence
- how to put slash(/) after a number
- Resizing to A4
- offset()
- How to change the font size of selections in a listbox?
- Excel Macro: use of 'if' command
- No worksheet tabs or scroll bars in worksheet
- Clears the content of a cell in a row
- Accessing MS Clipboard Items
- MS queries in EXCEL
- Copy & Paste Object without using the Excel Copy Paste functions
- Hyperlink
- Calculating Years/Months/Days when subtracting one date from another
- Templates and Custom Toolbars?
- Time: convert 1.25 to 1.15 (one hour, fifteen minutes)
- display is not zero
- DDE over network
- Excel Format - Apply number format based on formula
- finding data relating to max
- Highlighting Rows
- Convert Date format to Text
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.