DO NOT USE THIS TAG!

learn more… | top users | synonyms (1)

1
vote
2answers
8k views

Excel: text values in a pivot table?

I have a table (in MySQL) with 3 columns: Location Category Supplier A Computers Company X A Printers Company Y B Computers Company X B ...
0
votes
2answers
2k views

PowerPoint 2007: Setting custom cell margins causes text to display as if centered

I'm using PowerPoint 2007 and have pasted in a table from Excel 2007. When I paste it in it automatically becomes a PowerPoint table, and looks fine. However, everything is quite squashed together, so ...
1
vote
1answer
370 views

Table AutoExpansion incorrectly changes formula

I have a table in an Excel sheet where one column is calculated. When adding a new row by typing, the table automatically expands, but wrongly changes the formula of that column in the row above. It ...
2
votes
1answer
2k views

How do I move a table structure down in written documents?

I often run into this issue: I have a table (as in data in a table format) and the table is at the start of a document or email. I wish to move the table down the page but my cursor will only move to ...
0
votes
0answers
176 views

Want a software which can create image based product comparison tables for websites [on hold]

I'm looking for some software or web-based tool which can create image based comparison tables for putting on a website, which can be used to comparing different products .. However the angle is that ...
1
vote
0answers
39 views

I would like to highlight/shade table cells in two colors

This does not seem like a possiblility unless I can highlight the text in a second color. Can I add more highlight colors to the options available?
0
votes
1answer
129 views

How to create form that allows only one character in a cell

I would like to create a Microsoft Word document (doc or dot), that faciliates filling a form (or a table) in such a way that user types one character and the cursor is moved to the next cell. Like in ...
8
votes
9answers
16k views

How do I get rid of the extra space in tables with Microsoft Word 2003?

I am copying and pasting tables from another document (Word 2007) over to Word 2003 and when I do this, right click on the upper left hand corner of the table, AutoFit, AutoFit to Contents, I am left ...
3
votes
2answers
8k views

How do I pull data from multiple tables into one table in Access?

I have multiple tables that contain tasks according to their category. Each table represents that category. What I need to do is create a 'Master' table that then is able to pull data from ALL the ...
4
votes
2answers
44k views

How do I set the first value of AutoNumber in Access?

I don't need to reset the AutoNumber value like this question, but rather would like to first set the number to: 1001 Which then increments like normal: 1001 1002 1003 ... ...
3
votes
2answers
27k views

How to adjust the thickness of SOME lines in a Word table

I have a table in Word 2010 and would like sets of rows to be distinguished from other sets, but still all be in the same table. So, I would like a thicker grid line between some of the rows. But I ...
0
votes
1answer
192 views

Start database in Fedora 13

How can I start to create, delete, etc., a table in Fedora 13? How can I initiate to create a basic table in Linux, what are the commands? Will I have to install firstly a database like ORACLE in my ...
2
votes
1answer
165 views

Combining more than 10 tables data in to one table

In Excel 2003 I was able to combine more than 10 tables' data in one pivot table through "Multiple Consolidation Range". However I couldn't seem to find the same option to do it in Excel 2007. Any ...
0
votes
2answers
362 views

Delete table in Writer but preserve the contents

Is there a way to "explode" a table in OpenOffice.org Writer? That is, delete the table, but preserve its contents in the document?
5
votes
3answers
2k views

Flickering tables using Office 2002 on Windows 7

We are currently using Office 2002 on Windows XP but will be moving our users to Windows 7 in the next few months. Part of our business is writing research documents so there is heavy use of Word ...
2
votes
1answer
725 views

How can I prevent a table within a list from continuing the numbering scheme?

I'm writing a list of steps for some documentation, and want a simple table to show some settings based on conditions. The problem is that Word is adding a number to each cell in the table, when the ...
1
vote
2answers
651 views

Separate tables or single table with queries?

I'm making an employee information database. I need to handle employees that are separated from the company. Should I a. set up a query with a macro to send separated employees to a separate table, or ...
0
votes
2answers
1k views

How to line up text beside a table's row separators?

this is driving me mad: I need to write text that lines up like this
1
vote
1answer
349 views

Word Numbered List Issue — within tables & boxes

Is it asking too much of word to renumber lists within tables within inserted objects (standard rectangular boxes etc.)?
1
vote
6answers
4k views

Excel 2007: “Format as Table” Increments Column Names

I love using the formatting styles for tables in Excel 2007, but in my data I'm using the same column name for multiple columns. When I format my table using the pre-defined styles, it automatically ...
0
votes
3answers
4k views

Dates not recognized as dates in pivot table pulling directly from SQL Server

My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is ...
4
votes
10answers
69k views

How to properly merge two tables in MS Word

I would like to merge 2 tables together in Microsoft Word. I have attempted to do the usual drag and drop, but I'm out of luck! I don't know if my mouse is the problem, but even if I use the touch ...
0
votes
1answer
2k views

Can't type text into table cell when form is protected in Word 2002

I created several tables in an Word 2002 document to act as a form for users to fill out. In some cells I added check boxes and dropdown lists for people to select options from. When I click on the ...
1
vote
1answer
1k views

Dynamic row height on Word tables, based on mail-merged contents

I'm having to work with some Word templates which contain nested tables of mail-merged fields. I need the row height of one of the child tables to have a minimum height but be able to expand (height ...
0
votes
1answer
2k views

How to add a footer to a table in Microsoft Word?

I have a table that is longer than one page. I have found the option to make the header of the table to be added to the second portion of the table after the page break. Is there a way to do the same ...
0
votes
1answer
2k views

How can I import a CSV file into an SQLite table that doesn't allow null values?

I've been using the SQLite Manager extension for Firefox to edit my Chrome web data file in order to restore my keyword searches, and I think I have everything in place except that when I import a CSV ...
0
votes
1answer
428 views

How to maintain normal ICS routing after the ICS host connects to a VPN?

I have two computers in my home sharing an internet connection. They both have Windows XP and are connected together with a cross-over cable and share the internet connection via Windows ICS. The ...
1
vote
1answer
932 views

Route Split for OS X

I'm attempting to install a static route for a Mac Pro desktop. I'm using Route Split 1.4, which creates a startup script called /etc/routes.sh (the script waits for the interface to come online ...
0
votes
1answer
1k views

Is is possible to apply separate formatting to multiple different Excel table columns?

I have some calculated columns in an Excel (2007) table. I'd like to distinguish them visually from the user-input columns in some way, but without losing the nifty automatic row banding. It looks ...
1
vote
1answer
3k views

Pasting into multiple table cells in MS Word 2007

The situation: I have the text "123-456" in the clipboard, cut from typing earlier in Word. I then create a 4x4 table, select all cells within that table, and then select Paste. The end result I'm ...
0
votes
3answers
4k views

How to use excel to disply a list of cells, depending on dropdown box selection

What I want to achieve: select list A, B or C from a dropdown, when pressed, list of values displays underneath. I would also like the list to be populated from items in a table (which would have ...
2
votes
1answer
730 views

Exporting a subset of an Excel sheet as a (clean) HTML tab

I have an Excel sheet with several sheets and containing quite a few tables of information which are really intended to be published on a common wiki at my company. Previously, we used to use ...
6
votes
3answers
32k views

How do I insert text above a table at the top of a Word document?

This seems like it should be so basic, but it apparently isn't very intuitive. The scenario: (1) I've inserted a table into a new blank MS-Word document. (2) I want to add some text outside and ...
1
vote
2answers
1k views

Is there a way to give an Excel table a name that is worksheet-scoped instead of workbook-scoped?

When you create a table in Excel (I'm using Excel 2007) you can give it a name that shows up in the Name Manager dialog. However, the name has workbook scope. I'd like to have a table with a name ...
1
vote
2answers
312 views

How frequently do routing tables change in core-network routers?

How frequently do routing tables change in core-network routers? Once every 30sec? once every minute? every 5minutes? I know that there is a Border Gateway Protocol that runs in the core Internet ...
8
votes
2answers
7k views

How to open several tables in different tabs in SQL Developer

I have several schemes and need to open different tables in different tabs from different schemes at the same time. SQL Developer opens the table view in the same tab. Clicking whilst holding Ctrl ...
0
votes
1answer
2k views

How to move a table row in Apple iWork Pages?

Is it possible to drag a table row to a new position in order to reorder them? Things we've tried Drag the row: either swaps or overwrites (perhaps depending on Pages version?) Drag the row with ...
2
votes
2answers
2k views

Excel: lock sheet, but keep tables expandable

My goal is to protect a sheet, but make users able to edit and add rows to the contained tables. When I try to protect the sheet with no cells locked, the tables become unable to add rows even though ...
1
vote
3answers
13k views

Merge table columns in Word 2003 or Word 2010

How can I merge two table columns in Word 2003 or Word 2010?
12
votes
7answers
29k views

Table Formatting in Excel 2007: How do I remove it?

I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it ...
1
vote
3answers
559 views

Import table from a image to a spreadsheet

How can I import a table from a scanned image (jpg/pdf) file to a spreadsheet? Example scan is here
1
vote
1answer
291 views

long table in excel - how to produce stats for subtables?

(new to excel - ) say I have a table with columns A = {1..5}, B = {a..e} and Score = Number. I want to produce a new table that would display statistics for each A,B combination, e.g. A B Mean ...
1
vote
1answer
4k views

Excel cell references not updating when referenced cells are sorted

There are two tables, each with 75 entries. Each entry in the 2nd table calls an entry in the first table a parent. One of my 2nd table columns contains the "Parent Price", referencing the Price ...
2
votes
1answer
637 views

Resources about Excel tables and structured references?

I'm new to Excel-post-2000, and I'd like to learn more about how to use tables (formerly lists) and structured references. Can anyone point me to some good treatments of this topic that go beyond the ...
0
votes
3answers
2k views

Fixing corrupt files or corrupt file table on a USB drive?

I was doing a virus scan on an external USB drive while copying data over to it. While AVG was scanning my system got locked up I think due to the USB drive running out of space and it required a ...
6
votes
4answers
7k views

How to set up application-specific routing table on Windows?

Suppose network interface 1 (net1) and 2 (net2) are both connected to the Internet. I want application 1 (app1) to use net1, and application 2 (app2) to use net2. How can it be done under Windows? If ...
0
votes
0answers
588 views

Link Table manager does not work

I have access 2003. When I use the link table manager to link to a back end it does not work. There are no error messages. It just flashes and keeps asking begging for the location of the BE which ...
1
vote
1answer
299 views

Tool to make a DIFF between HTML tables?

I am seeking a tool to make a DIFF between tables displayed in HTML tables - typically tables with identical layout, filled only with numbers, the numbers differing from on version to another. Raw ...
0
votes
1answer
110 views

How do I make a Little Schemer like layout in latex?

I want to make a two-column table that spans the entire page and is laid out something like this: =================================== Column 1 text Column 2 text ...
0
votes
2answers
2k views

What is lookup tables in excel?

I have the below entry when i go to the insert > name > Define name ='Lookup Tables'!$I$29:$I$65 what does it mean ?