A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Excel should let me create pivot tables of non-numeric data. by Geek4Life
Basically, the need is to build multi-dimensional tables of text. This would be more ideal in Word, but Excel PivotTables comes so close...if only it...
April 25th 17 11:07 PM
by GS[_6_] Go to last post
4 839
Crystal Reports export to Excel - Loss of Leading Zeros by [email protected]
On Monday, November 1, 2004 at 11:48:04 AM UTC-4, CR-Tech wrote: > Crystal Enterprise is the web-based front-end server which displays > stored/linked Crystal...
April 25th 17 07:16 PM
by GS[_6_] Go to last post
1 35
break links not working by swoxo
In Excel 2007, I have a workbook with one link that I want to break. In the Ribbon, I go to the Data tab, and in the Connections section I choose Edit...
(Multi-page thread 1 2 3 ... Last Page)
41 12,504
Advanced filter using dates by Rusty
I have a column formatted as a date field and need to do advanced filtering on it. For example, I want to filter out entries between two dates. When I build...
April 20th 17 05:11 PM
by excel_vba Go to last post
3 2,465
how can i get the labour market economics 7th edition test bank? by [email protected]
how can i get the labour market economics 7th edition test bank?
9 1,929
Copying a worksheet - won't work help please by [email protected]
On Sunday, March 5, 2000 at 11:00:00 AM UTC+3, Ber Visser wrote: > The easiest way to copy a worksheet is to select its tab and, whilst > pressing Ctrl and the...
April 18th 17 06:38 PM
by Dave H Go to last post
1 142
Can I keep external connections in a table? by Dave H
Currently I have worksheet that pulls in a query from an external source. Then I have another worksheet that references the external query, this sheet is...
April 18th 17 02:59 PM
by Dave H Go to last post
0 51
Can I arrange tabs vertically in Excel (not horizontally)? by LinLin
I use a lot of tabs / worksheets in a spreadsheets and if I could view them vertically (ie on the RHS of the screen) I could fit more tabs in! Is there...
(Multi-page thread 1 2)
13 2,105
Can you print multiple worksheets double sided? by Publisher Lyn
We publish an annual publication of detailed tables. Each section of the book is created in a single Excel workbook - each page of the book is one Excel...
(Multi-page thread 1 2)
April 9th 17 03:09 AM
by cacuoc334465c Go to last post
16 4,453
Hi all, How do I ask Excel to stop "rounding"? I know Round up and down functions however I want excel to stop "rounding" and do not take into account the...
April 5th 17 10:20 AM
by pedro Go to last post
1 221
how to unhide multiple rows in one go? by Satnam Randhawa
I have a worksheet with close to 100 rows out which 15-20 are hidden. How do I unhide all the rows in one work sheet in one go without having to drag them...
(Multi-page thread 1 2 3 ... Last Page)
41 13,132
File Path Too Long? Not Anymore! Check out Long Path Tool by Max Loger
http://LongPathTool.com Long Path Tool recognizes the processes or running programs which have locked those files, preventing them from being renamed, moved...
March 24th 17 07:59 AM
by liona1982 Go to last post
1 971
words in cell keep repeating by Hyde Park
In a worksheet that has been created and that we used repeatedly in our business, one cell keeps repeating the name we are placing in it. Such as we type...
7 2,259
Adding the same field in the column field list of pivot table by nanka
Hi, I am showing the %row total of certain categories per week in the pivot table. The source is a query table. When i am clicking insert I create the pivot...
March 19th 17 03:17 AM
by nanka Go to last post
0 196
Print titles must be contiguous and complete rows or columns by [email protected]
On Thursday, June 17, 2010 at 9:50:35 AM UTC+5:30, tanvnit wrote: > "Print titles must be contiguous and complete rows or columns " > > solving this error :...
0 196
Cursor cell selection "won't release" by nitewowl
This is happening within an open spreadsheet. Somehow I have accidentally hit something or some combination of keys that makes the cursor "stuck" in...
6 1,056
how to use “or” in excel solver constraint? by Hossam Shehata
Good Day I want to add a constraint to excel solver X = 0 or 2 that means x equal to only 0 or 2 how can I add this constraint to solver?
March 14th 17 08:42 PM
by Hossam Shehata Go to last post
0 157
Activate a workbook? by Terry Pinnell[_4_]
I added a line Workbooks("Walk Index.xlsm").Work.Activate at the end of my copying macro, to ensure that the workbook 'Walk Index' was in...
(Multi-page thread 1 2 3 ... Last Page)
March 14th 17 05:38 PM
by Terry Pinnell[_4_] Go to last post
38 729
How to handle Brackets [ ] by Milo Bloom
I have a formula I want to put into Excel and I tried using () instead of brackets and I do not get the correct answer, Below is the...
March 13th 17 10:11 AM
by Terry Pinnell[_4_] Go to last post
2 295
=+SUM by FJ
Hi, I have a question: I was given a spreadsheet to work on and all the SUM formulas have the following format: =+SUM(A1:A10). I have never seen this...
(Multi-page thread 1 2)
12 830
Post New Thread

Display Options
Showing threads 1 to 20 of 146451
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.