The tables tag has no wiki summary.
0
votes
1answer
18 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 ...
0
votes
3answers
33 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.
...
-1
votes
0answers
16 views
Counting the number of people in a team with an SQL Stored Procedure [closed]
I am wanting to create a stored procedure that accepts the team name and year and returns the number of players in that particular team for that particular year. I am working with MYSQL and listed ...
2
votes
1answer
77 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
15 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
0answers
25 views
Macro to collapse section of table in Word 2003
I was wondering if it's possible to hide/collapse a section of table in Word. It's like when the user hit "NO" button the section of table for detail information should hide/collapse. I know the ...
1
vote
1answer
470 views
Cut in excel doesn't work, and copying tables from one program to another returns text
My excel 2007 on Windows 7 operating system seems to have a probelm with regular cut function. when I highlight cells I want to cut and press cut (either on keyboard shortcut Ctrl+x, Home menu cut ...
0
votes
0answers
42 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
43 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 ...
0
votes
0answers
80 views
Microsoft Word hidden table rows don't stay hidden
I have a moderately large Word document, mostly containing tables. I hide rows in the table when I'm through with them. I don't delete the rows, because it's not unusual to need to refer to them ...
0
votes
1answer
79 views
Is it possible to autoincrement a certain column value in MS 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
23 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
164 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 ...
0
votes
0answers
41 views
MS Word 10 won't allow me to enter a caption for some tables
Most of the tables in this document accept captions. However, there are about 3 of 15 where when I select the table & right-click there is no 'insert caption' option. No matter how many times I ...
1
vote
2answers
175 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
1answer
45 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
113 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 ...
1
vote
3answers
300 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
61 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
285 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 ...
0
votes
1answer
81 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 ...
3
votes
2answers
353 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 ...
0
votes
0answers
113 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
1answer
465 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
290 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
99 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
165 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
94 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
75 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
212 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
1k 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
1answer
179 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 ...
0
votes
1answer
70 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 ...
1
vote
1answer
179 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
67 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
21 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
36 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 ...
1
vote
2answers
818 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 ...
2
votes
2answers
582 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 ...
3
votes
2answers
3k 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
...
...
1
vote
1answer
429 views
How can I include only part of an image caption in a table of figures in Microsoft Word?
How can I include only part of an image caption in a table of figures in Microsoft Word?
For my dissertation I am writing long captions on all my figures. This makes my table of figures very ...
1
vote
1answer
2k 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
122 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
101 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
1answer
97 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?
3
votes
3answers
558 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
84 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
280 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
1answer
474 views
Microsoft Word: 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
0
votes
1answer
113 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.)?
