The tag has no wiki summary.

learn more… | top users | synonyms (1)

4
votes
1answer
3k 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
3k 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
329 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
1k 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
200 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 ...
1
vote
3answers
3k 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
87 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
2k 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
95 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
563 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
1k 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
473 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
653 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
764 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
370 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
107 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
2k 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
5k 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. ...
2
votes
1answer
4k 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
395 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
249 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
654 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
1k 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
515 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
636 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
8k 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
190 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
369 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 ...
4
votes
3answers
10k 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
192 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
3k 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
1k 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 ...
4
votes
2answers
2k 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
867 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
12k 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
682 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
321 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
417 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
0answers
304 views

Org-mode - table columns alignment - little tweak

In org-mode when I am using tables I need either to set up somehow or change algorithm of alignment in columns. By default there is text aligned to right with one whitespace character prepended. If ...
1
vote
1answer
286 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
0answers
657 views

How to reset/change owner information of Fujitsu Lifebook T4220

I have bought a used Fujitsu Lifebook T4220 tablet, but the previous owner has set the owner information in the bios, and it can't be changed after setting it, how can i remove, reset or change it?
1
vote
2answers
7k 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
314 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
1k 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
165 views

Want a software which can create image based product comparison tables for websites

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
113 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
12k 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 ...