DO NOT USE THIS TAG!

learn more… | top users | synonyms (1)

3
votes
2answers
2k views

How to efficiently insert a table from R into a Word document?

I am creating a Word document (.docx) using LibreOffice. I need to include some numeric results I calculated in R. They look like a simple table of numbers, with text captions for the rows and ...
1
vote
2answers
221 views

Any lightweight Linux/Cross-platform text editor that does tables?

I like to organize info in tables. OpenOffice/LibreOffice is too heavyweight, I don't need the hit to swap nor the featureset. Is there any lightweight editor that does a table/grid like that, and can ...
2
votes
1answer
23 views

Enabling the User to Insert the Data in Access Database

I have created a data model in Access Database. Tables that are composite parts of the model are loaded with data. Some of the data needs to be loaded manually. Now I would like to link couple of ...
2
votes
3answers
5k views

Excel 2010: How can I obtain a one-to-many rows table by merging duplicated cells in a large normalized table?

As I am a newbie when it comes to Excel (and the entire Microsoft Office suite, to be honest), I spent a lot of time browsing for a solution to this issue - how to get a one-to-many rows table out of ...
1
vote
1answer
4k views

Push cell down automatically in excel (2010) table

I don't know if this is the right forum to ask this I have the following table in excel it is formatted as a table except the total ----------------------------- | Item | Description | Price | ...
1
vote
1answer
100 views

How to make numbered tables with numbers that take no space in Microsoft Office Word?

I have a few tables with symbols in Word and I want to number them, but numbering seems to take a huge amount of space from each box which makes the whole thing look horrible. I can't even see half ...
1
vote
1answer
923 views

How can I stop Word duplicating all the words when I convert text to a table?

In Microsoft Word I have a list of words, one per line, many pages, like below: xxxx yyyy zzzz aaaa bbbb When I copy these lines and paste them into a 1x6 table it becomes like: xxxx xxxx xxxx ...
1
vote
2answers
2k views

How do I group rows in a table by one column's value in Excel?

I have a table of data (5000+ rows) with two columns, ID and value. It may look like this: ID Value 01 02 01 03 01 17 02 05 03 06 03 28 What I want to do is find the average value for each ID. ...
4
votes
2answers
610 views

Using Emacs align-regexp to format tables

Vim has the neat Tabular plugin that allows you to quickly align some text. I use it a lot to align blocks of code along a certain character (mostly things like = and =>). But it also does a very ...
2
votes
1answer
1k views

Multiple tables in Microsoft Access that need to feed into one table

In my Access (2010) database, I have 4 linked tables (from other Access databases) that I would like to feed into one table, or query. I've tried using the query design but can't seem to get it right. ...
0
votes
3answers
985 views

Excel 2010: Do sortable tables support sorting within multiple columns?

In Excel 2010 (and perhaps recent versions), you can select a range of data and insert a table over it that adds user-friendly sorting capabilities to the data. However, it appears that it doesn't ...
0
votes
1answer
433 views

How to reset to default in Word 2003 the setting “Allow row to break across pages”?

MS Word MVPs suggesting creation of a table style, replacing the default one to have the rows broken across pages disallowed globally. Is there a step by step explanation?
0
votes
1answer
110 views

Extracting Excel-published tables from a PDF document

I'd like to copy Tables 1,2, and 3 found at the bottom of this PDF file: http://www.cbo.gov/sites/default/files/cbofiles/attachments/03-13-Coverage%20Estimates.pdf into Excel. I've tried Copy+Paste ...
1
vote
1answer
3k views

Use Excel Table Column in ComboBox Input Range property

I asked this in StackOverflow and was redirected here. Apologies for redundancy. I have an Excel worksheet with a combo box on Sheet1 that is populated via its Input Range property from a Dynamic ...
2
votes
5answers
7k views

MS Word to PDF. Corrupted tables borders

I´m having problems while saving a MS Word document (.doc OR .docx) to PDF (by saving it directly as PDF from MS Word, printing it with the Adobe printer, etc) on how the tables borders are displayed. ...
4
votes
2answers
6k views

How to make a table span two columns?

I am making a two column document, but I have a large table that I want to make span the columns. How can I do this in Microsoft Word? ................................ TABLE ...
0
votes
1answer
689 views

In Microsoft Word 2010, after I updated my Table of Contents, it is displaying a chart (from the document) how do I correct this?

The Table of Contents link should just be to the heading on the page, which is the name of the chart. I don't know why it is bringing in the whole chart.
0
votes
1answer
321 views

Are there any Microsoft Word 2010 table styles ? The nice looking ones instead of current ones

Such as table styles that are using nice gradients or effects. Are there any styles that i can download and use ? Microsoft office 2010 or 2007 Word tables.
0
votes
1answer
882 views

Word 2007 different row counts for columns

I'd like to create a table in Word 2007, having X columns, and for the first column, 5 rows spanned across the whole table, followed by every other column having 17 rows. Merging isn't available for ...
1
vote
2answers
2k views

Is it possible to autoincrement a certain column value in Microsoft Word Tables?

I have a big table on a MS Word 2007 document. The left most column is named 'serial' and it's values increment starting from one. Now, this can be achieved automatically in Excel, is this possible ...
0
votes
1answer
1k views

Form no longer updates table; what'd I do?

I've been working on an "Enter Scores" type of form for a database that's used in a competition. What should happen is - I pick a team from a combobox, enter their score in a text box, then upon the ...
2
votes
1answer
774 views

Copy Word table and make it default in Word

I have a nice custom table design in Word 2010. I wish to allow my colleagues to use this table design as their default table template for Word and Outlook. In my own test, it would magically appear ...
4
votes
3answers
10k views

Is there a way to change background color for a table in onenote?

In word or excel or power point you can change the background color of a table or selected rows or columns of a table, but I can't find a way to do this is onenote. Is there a way to do this?
0
votes
3answers
254 views

Where are microsoft access tables stored?

Does Access store tables and data outside of the *.mdb file ? I have a computer which currently has a large working database on it containing some tables with confidential data. I would like to ...
1
vote
1answer
433 views

Updating a table in oracle using another table rows

I want to update each row of a oracle table based on another table's rows. To be more specific, There's a table called Contact with the following fields: code(PK), name, mobile, email There's ...
8
votes
4answers
18k views

Excel table - delete rows not in filter

i have a very large table in excel (1000's of rows) and i filter it to only show 10 rows. I wonder if there is a way to delete the rows not shown [ ie dont meet filter conditions]? this would enable ...
0
votes
1answer
272 views

Prompt to select excel spreadsheets in Access?

I have a Microsoft Access 2007 database that uses excel spreadsheets to track changes between the two. A new file is generated every week. I then do a compare against the two of them with some custom ...
2
votes
5answers
4k views

How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?

Consider a table of employee name, age and employee manager. Employee manager is a reference to employee name in same table but different row. I tried this by referencing cell =A3 Now if I sort ...
1
vote
1answer
2k views

What formatting is applied in this Word 2010 table, and how can I prevent it from being applied in tables by default?

When I insert a table in my document the text in the cells looks like it is aligned to the top of the table. Only when I click the remove formatting button or apply the default style is the text ...
6
votes
2answers
3k views

How to paste table from MS Excel to Wolfram Mathematica?

When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica. How to have a ...
2
votes
2answers
1k views

How can I create a custom OpenOffice / LibreOffice Writer table AutoFormat scheme?

None of the basic table AutoFormat schemes in LibreOffice Writer have both an alternation style defined and no sum column/row style defined. If they have alternation, they always seem to have sums. ...
1
vote
3answers
17k views

How can I copy tables between word documents without having the format change?

I have two both word 2007 documents, A and B. I want to copy a table from A to B, and that table's format is totally the same as I see in A, not automatically changing the format to B's template ...
0
votes
4answers
379 views

What is the best way to manually edit and update data within a large table in MS SQL Server?

I have a table in MS SQL server which currently has around 800 records and 20 columns. I want to manually update and add to the information within this table on a frequent basis. Would exporting the ...
1
vote
2answers
533 views

Filter and reorder columns in Excel

I've got a service (phplist, a newsletter manager) that exports a user list with several fields. At the end of it, each user has one or more lists to which he has subscribed. The problem is, that ...
1
vote
1answer
369 views

Equivalent to rowspan in Microsoft Word tables

Is there an equivalent to the HTML tag rowspan when creating a Microsoft Word table? I seem to only be able to create rectangular grids.
1
vote
2answers
9k 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
3k 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
396 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
138 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
20k 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
9k 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 ...
5
votes
2answers
48k 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
32k 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
195 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 ...
0
votes
2answers
402 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
836 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
686 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