DO NOT USE THIS TAG!

learn more… | top users | synonyms (1)

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
382 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
1answer
130 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
17k 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
45k 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
29k 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
193 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
381 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
762 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
664 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
356 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
72k 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
3k 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
433 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
934 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
742 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
34k 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
325 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
30k 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
561 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
292 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
642 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
8k 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 ...
1
vote
1answer
306 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
111 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 ?
0
votes
4answers
6k views

Insert line into an existing table in Microsoft Word 2007?

This is driving me nuts! Is there a way to quickly insert a line to an existing Word 2007 table? In Word 2003 there was a specific button for this - it was quite easy to splice and dice existing ...
1
vote
2answers
594 views

New Scribus 1.3.5 (Win): Use tables

I'm using the new Scribus 1.3.5 under Windows. It was never fun to work with tables in it, but now they are literally useless. My problem: After spanning a table, it seems as if it is only a bunch of ...
4
votes
5answers
6k views

How can I extract text from a table in a PDF file?

I am trying to implement an algorithm described in an academic paper, which I have in PDF format. The algorithm includes a table of 256 entries that I want to copy to my implementation. However, I ...
6
votes
9answers
83k views

Rotate a table in word

I have a word 2007 document in portrait mode. I have a table that is too wide to fit in 8.5" but would fit in 11". Is there a way to make just one page landscape? Or alternately is there a way to ...