DO NOT USE THIS TAG!

learn more… | top users | synonyms (1)

0
votes
1answer
32 views

Excel Statistical Table

I am trying to create a statistical table based on columns of information. The row/column identifiers of the table are also incorporated in part of the statistics of the table. I have three columns of ...
0
votes
1answer
165 views

Excel or Access: how to group several lines in a table and insert contents in columns? (“split column”)

I have a table containing data of sold products (shown in the example on the left): Columns: Number of the order Product Name Attribute - specifies what is given in the following field "value", e. g. ...
1
vote
2answers
222 views

Merged rows in column, bottom row fixed height

I've been struggling some time now with a specific problem using Tables in MS Word (2010). I have a table with 2 rows and 2 columns and the last column, the rows are merged. Now it can happen that ...
0
votes
2answers
47 views

getting data from several columns in a record

I have excel sheet contains the following table: I want to get the last recent DATE with its LAB Result?
3
votes
1answer
1k views

Interactive console based CSV editor

Although spreadsheet applications for editing CSV files on the console used to be one of the earliest killer applications for personal computers, only few of them and even less documentation about ...
0
votes
1answer
89 views

How to create a table with blank borders in Word 2003?

I cannot seem to find any way to create a table with blank borders in Word 2003. Is this possible, and if so, how?
-1
votes
1answer
836 views

How to add a table beside text on multiple lines in Word 2010

Basically, I'm working on a resume and having a hard time getting the layout I want. I have a title for my coursework section called "RECENT COURSEWORK", with each word on a separate line. I want a ...
0
votes
1answer
53 views

Convert text to table

I would like convert text into a table. Here is a link to the text http://www.tcdb.org/public/tcdb Short example: >gnl|TC-DB|A0CIB0|1.A.17.3.1 Chromosome undetermined scaffold_19, whole ...
0
votes
2answers
6k views

hod do i grep multiple keywords from a file?

I want to use unix's grep function to pull out multiple lines (with different key words) from a file in one command line. e.g. i have something like doc-A1-151 file-A2-15646 table-A3-1654 ...
4
votes
1answer
5k views

Restricting table cell resizing in Word

Is it possible to restrict users from resizing the cells of a table in protected documents in MS Word 2010? I want to restrict them from making any changes to the layout of the table (or, at least, to ...
1
vote
1answer
5k views

How to make a color gradient in a Word 2010 table cell

I would like to make a gradient background in a Word 2010 table cell. Unfortunately, Word only provides solid color filling and premade patterns. There does not seem to be an easy way of doing this. ...
1
vote
1answer
480 views

MS Word 10 table won't delete

I created a table. Now everytime I start Word 10 the initial table I started with comes up instead of a blank document. I have tried many different ways to delete the table but everytime I re-open ...
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
215 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
0answers
91 views

Is it possible to create a table structure to an existing data in word 2007?

I have some data that is organized properly in MS word 2007. Now I need to put this data into a table structure. Since there is so much of such data I just cant manually arrange them. Is there a way ...
1
vote
1answer
3k 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
98 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
878 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
589 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
959 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
421 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. ...
3
votes
1answer
5k 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
622 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
305 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
842 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
752 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 ...
3
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
236 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
423 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
17k 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
263 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 ...
5
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
16k 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
1answer
764 views

Pasting HTML table into Excel 2007 without modifying the format of each cell

I have a table in HTML having cells storing numbers like 123.0,123.00. When I use ctrl-A to copy the whole page into excel, 123.0 and 123.00 are all changed to 123, which is not something I want to ...
0
votes
4answers
369 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
512 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
343 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 ...